Posted by Erland Sommarskog on 12/09/05 21:50

Luca Drink (luca.bevilacqua@gmail.com) writes:
> Hello everybody,
> does anybody know how to export databases from SQL Enterprise to SQL
> Express 2005?

The simplest would be to take a backup of the database, and restore it
on SQL Express. You can also detach, copy and attach the databases.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Strange FK relationship - how, and is it right?
• Prev in forum: Re: SQL Debugging Tool
• Thread view: Re: Export Data from SQL Enterprise to SQL Express 2005

[Reply to this message]