Converting a SQL Server 2000 or 2005 Database into a SQL Server Express database??

Posted on 2007-08-10
Last Modified: 2010-03-19

Is it possible to Convert a SQL Server 2000 or 2005 database into a stand-alone SQL Server 2005 database keeping all views and sprocs from the Server database? If so, how do you do this?

Question by:Saxitalis
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    with "stand-alone", you mean a single-file like a ms access mdb database?

    that is not possible per se. to use a sql server database, you always need a full sql server installed.
    you can however detach the database, and copy over all the files of that database (.mdf, .ldf, .ndf etc), and attach them to another server.
    note: the attach process only works into the higher or equal versions, going back from sql 2005 to sql 2000 does not work
    LVL 3

    Expert Comment

    What do you mean with "standalone"?
    If you want to move a SQL Server database from a server to another one just do a backup and restore.
    You can backup a SQL 2000 or 2005 and restore on a SQL 2005 any version.

    Author Comment

    My application is built on a full SQL 2005 Database. I would like to create the app for users who do not have access to SQL Server 2005 standard and may not have a network. I know that SQL server 2005 Express is free so users who don't own SQl Server 2005 can still run my database one one machine only (my app and SQL Server 2005 express). I know how to move files around between databases in SQL server 2000 or 2005 by detach/attach.

    Can you attach a detached db files from SQL server 2005 Standard edition to the (free) 2005 express edition?

    LVL 3

    Accepted Solution

    Yes, you can attach/detach a SQL server 2005 database from Standard to Express edition.
    The database format (.mdf and .ldf files basically) is the same for each version. The differences are in the SQL engine, in the services available (SQL Express doesn't have a SQL Server Agent Service, for example) and so on, but the databases can be moved back and forth each SQL server 2005 version.

    Author Comment

    Thanks for the info !!

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    729 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

    20 Experts available now in Live!

    Get 1:1 Help Now