January 10, 2006 at 1:36 pm
Hi All,
We have recently migrated some databases to new server. Next day we got to know there is some conflicts in database collation. According to microsoft we done some changes to database. Here for example take xxx database.
Below is the procedure microsoft had suggested.....
1) Created a new database with other name like xxx_Duplicate
2) Imported all data from original to duplicate.
3) Created a package and imported all produres and tables to duplicate.
4) Renamed this xxx to xxx_Ori and duplicate to xxx.
Here my problem is still application is pointing to xxx_Ori. And also some stored procedures also pointing to xxx_Ori database.
Please some help out....This is very urgent
Thanks in advance.
Regards,
Anil Kumar
January 11, 2006 at 4:01 am
01. Select All Stored Procedures
02. Right Click, All Tasks, Generate SQL
03. Find and replace xxx_ori to xxx
04. Delete all the Stored Procedures
05. Execute the modified script from QA
Jagan
January 12, 2006 at 10:50 am
Just write a script to do the restore and you won't have to create a db name on the server before hand. It will also restore all objects.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply