Move data from MSDE to SQL 2000

Posted on 2005-05-16
Last Modified: 2010-03-19
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.
Question by:Idarac
    LVL 24

    Expert Comment

    by:Jeff Certain
    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...
    LVL 24

    Expert Comment

    by:Jeff Certain
    Sorry... post to the wrong question...
    LVL 11

    Accepted Solution

    backup the MSDE then restore it to sql server - that is about the simplest way
    LVL 1

    Assisted Solution

    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.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how the fundamental information of how to create a table.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now