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 |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2004-04-13 : 13:20:16
|
| Wondering if someone can help me..I have a database on ServerA which is running SQL 7.0 and I would like to move this database to ServerB which is running SQL2000. What is the best way to do this. 1) Can I backup SQL7.0 database on Server A and copy it to ServerB, than create a DB with same name on Server B and restore it using the backup file. I tried that and when I click on the newly created DB on ServerB i get the following messager: IE Script Error. An error has occured on in the script on this page. Line 307 char 2 error:unspecified. Code:0or 2) can I use the migration Wizard from Server B and import the database this way. I tried that too however my application folks are complaining that they do not see everything (tables,etc.) on the new server. I did not receive an error when migrating.So I'm sure you folks have done this in the past so please tell me what is the best way to go about migrating and how can I move users who are attached to the database also.Your help will be greatly appreciated.Thanks,Jay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-13 : 13:24:09
|
| To move from SQL 7.0 to SQL 2000, you can BACKUP on 7.0, then RESTORE on 2000. It actually performs an upgrade. What is the command that you used to RESTORE the database. You can also detach the database on 7.0 using sp_detach_db and attach it in 2000 using sp_attach_db if you can take the database down.I would not recommend the migration wizard.To move uses, you can use a stored procedure that I wrote called isp_Transfer_Logins. Search for it in the forums. Run the stored procedure first, then move the databases over, then run sp_change_users_login script to unorphan the accounts. There is a sp_change_users_login script in the script library here also.Tara |
 |
|
|
Jay1Jay
Yak Posting Veteran
50 Posts |
Posted - 2004-04-13 : 14:44:28
|
| Unfortunately, I couldn't find the stored procedures, isp_transfer_logins. Is it possible You can email them to me. thnxs my email is "BPATEL@chubb.com"...Thanks,Jay |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-13 : 15:28:31
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27826Tara |
|
|
|
|
|
|
Database Migration