• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

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

Hello,

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?

Thanks
0
Saxitalis
Asked:
Saxitalis
  • 2
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
0
 
ibrusettCommented:
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.
0
 
SaxitalisAuthor Commented:
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?

Thanks
0
 
ibrusettCommented:
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.
0
 
SaxitalisAuthor Commented:
Thanks for the info !!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now