Tech Off Thread

3 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

Migrating SQL Express data to SQL Server 2000

Back to Forum: Tech Off
  • User profile image
    mrichman

    Anyone know how to get the data out of my SQL Express instance from Visual Studio 2005 (~/App_Data/foo.mdf) over to my SQL Server 2000 box? Copying the .mdf file over and re-attaching it is not an option, since this is in a shared hosting environment.

    I was thinking of using SQL Enterprise Manager to connect to the SQL Express instance, and then DTS the tables and data over. How would I do this?

    Any other ideas?

  • User profile image
    dotnetjunkie

    This is really simple.
    Just let your SQL Express output an .sql file, that creates all the stuff on your SQL2000 (just execute it from management studio, or the old query analyzer, doesn't matter)

  • User profile image
    mrichman

    How do I do this from within Visual Studio 2005?

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.