Move data from MSDE to SQL 2000

I want to be able to use the MSDE for my development work and creating the database then when completed move the data over to SQL Server 2000. How do I go about doing this . I am using VB.Net as the front end interface.
Who is Participating?
backup the MSDE then restore it to sql server - that is about the simplest way
Jeff CertainCommented:
The connection strings should be identical for SQL and MSDE, assuming you have the same user in both servers, with the same password and same permissions...
Jeff CertainCommented:
Sorry... post to the wrong question...
MSDE files can be mounted through Enterprise Manager in the same way as a normal SQL Server DB.  You can use any method supported by Enterprise Manager/Query Analyzer to mount the MSDE files in SQL Server.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.