Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    30

    Unanswered: How to import data from MSDE to Sql Server?

    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!

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    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.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Sep 2003
    Posts
    522
    backup and restore is one of the options, but you can also just sp_detach_db/sp_attach_db

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •