September 19, 2007 at 12:47 am
We are having a SQL2000 database on WinNT server (Publisher) which we want to import into SQL2000 on a Windows 2000 server (Subscriber) and also want to replicate. What is the best procedure to follow? While importing database we observed that all stored procedures are not imported.
September 19, 2007 at 1:55 am
Sisir,
I makes no diference which OS you're using. What is important is the SQL Server version and what you mean by "Importing". Since you talk about Publishers and subscribers I assumer you'r using some type of replication. In SQL 2000 you have the option to replicate Stored Procedures and views, but be carefull using this option because any changes in the stored procedure will not be replicated automatically.
Maybe you could explain how you "imported" your database and what you're trying to achieve. Which type of replication are you using? It's difficult to give advice without really knowing what you need.
Markus
[font="Verdana"]Markus Bohse[/font]
September 19, 2007 at 2:39 am
We were having two SQL 2000 Standard (Below SP3 Service Pack) server whrere merge replication was giong on (Windows NT Server 4.0). We want to upgrade the system with new hardware and OS (Windows2000 or Windows2003 Sever OS) without loosing the data. We have loaded Windows 2000 OS and SQL 2000 Standard (Below SP3) in the new H/W(replacing the old subscriber) and imported database from the other one (Old Publisher). Though the import all option has not shown any error but we observed that all stored procedures are not imported. Replication was successful but quaries from our application not giving the correct result.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply