Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
 Posted - 2010-07-15 : 06:05:33
|
Dear all,I would like to tap your experience.There is one SQL Server 2005 with running transactional replication for 4 databases. The server is publisher and distributer.There is one SQL Server 2008 as a subscriber to these databases for simple reporting purposes.Now we need to update some table structures on that SQL Server 2005 and that means we have to stop the replication and restart the replication after the changes to the tables are made.Now my question is:What is the best way to do that?I don't know very much about that and would like to go the easiest way.My idea was a follows:° In object explorer right click on folder replication and choose Generate SQL Script. - to drop or disable the components - to create or enable the components° Run the created script to drop or disable the components° Do the needed changes to the table structure° Run the created script to create or enable the componentsWould that work?Is there something more to do?If this way will work is it then similar to Generate the scripts only for one publication if only one database has to be changed the table structure?Thank you
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-07-16 : 20:06:56
|
| first of all, if you are making changes to your articles you dont need to stop/restart replicatin.If you still want to do it, you can just drop the article form publishing, make your changes, add it back to the publication. The next time your sync agent runs it will create and copy a snapshot of the article. Repeat for each of your articles. IMHO you can directly run the schema changes. In SQL 2000 and before, you had to manually do a lot of things. Not so with SWL 2005 and above.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Stop and restart replication