September 26, 2007 at 11:43 pm
Hi,
We are trying to Import a SQL 2000 (Standard) data base on Windows NT Platform in to another server with SQL 2000 (Standard) on Wnidows 2000. While importing it shows successful data transfer but some of the User made Stored Procedures are not in the list. We have separately tried to import those store procedures but with same result. However when importing to Windows NT the problem is not there. Since those stored procedures are encripted we are not able to copy/Paste or create those in the new database. How can we get those SP in our new database?
Sisir
September 28, 2007 at 5:53 pm
You could try backup and restore that is backup the database in the old server and restore in the new one, you just put the .bak in the backup subfolder in Microsoft SQL Server folder in programs. Then go to enterprise manager and right click all tasks then restore and choose restore from device and make sure SQL Server creates the file path. This part is very important SQL Server gets confused if you create the path. The reason to use backup and restore is it is the only way to move everything in a database. There are known issues like orphan permissions just delete the restore and create a new one. Hope this helps.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply