Hi All, I am in the process of moving our database server onto new hardware . Some of the databases on old server are involved in replication. So my question is: (1) If I created the replication jobs same as existing old server and also script publiations from old server and run both the things ( replliation jobs and Publication ) at my new server...............Will this be enough (or) not............Will this work ....... Will database gets in synch. Please let me know what is the best way that I should be doing this task efficiently. Thanks.
See this http://sqlserver-qa.net/blogs/tools/archive/2008/01/22/upgrade-blurg.aspx blog post about upgrade proces when replication is involved. Stop the replication and once you have done the upgrade redefine the replication for better working.
