Transfering data from SQL Server Standard to SQL Server Express

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tapsavirtanen@yahoo.com - 28 Feb 2008 13:19 GMT

Hello folks,

Are there any tools that can transfer database and it's content from
SQL Server Standard version to SQL Server Express database?

I tried to backup database in SQL Server Standard and then restore it
into SQL Server Express but it didn't work. Are there any tools that
can extract SQL clauses to create database, tables
and data inserts into file? Or any other method to transfer database/
data from SQL Server Standard to SQL Server Express?

Cheers,

Reply to this Message

Erland Sommarskog - 28 Feb 2008 22:35 GMT

> I tried to backup database in SQL Server Standard and then restore it
> into SQL Server Express but it didn't work.

It should work. What happened? Did you get an error message?

> Are there any tools that can extract SQL clauses to create database,
> tables and data inserts into file? Or any other method to transfer
> database/ data from SQL Server Standard to SQL Server Express?

The Database Publish Wizard can be a choice.
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-
A410-371A838E570A&displaylang=en

Signature

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

Reply to this Message