I previously used MSDE as my web database, but now I've installed SQL Server Enterprise 2000 into my server. My question is how I can import data from MSDE to my new SQL server? I don't wanna lose all the data.
Thank you!Backup the database on MSDE. Restore them on the new SQL Server installation. After that, you'll want to sync up the logins. Search this site or SQLTeam.com for a script called sp_help_revlogin. You need to run that on the MSDE version, then apply the permissions to the new installation. After that you should be good to go.|||backup and restore is one of the options, but you can also just sp_detach_db/sp_attach_db
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment