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 |
|
jimmyp
Starting Member
1 Post |
 Posted - 2004-07-13 : 05:28:39
|
| I have an old server with an sql 7 database on it. I want to export the whole database including tables, views, stored procedures etc etc and put it into an sql server 2000 database. I have migrated the data using the export wizard but feel this is not the best approach and I am not sure how to migrate the views and stored procedures.Is there a better way? |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-07-13 : 05:51:40
|
| Yes. Backup the database, and then restore it on the new server. This will convert the database to SQL2000, and you will maintain all your DB objects. All you need to do afterwards is correct your logins. HTH*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
Exporting SQL Server 7