Transfering data from SQL Server Standard to SQL Server Express

[tapsavirtanen]

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,

[Erland Sommarskog]

(ta***********@yahoo.com) writes:

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/d...1C5-BF17-42E0-
A410-371A838E570A&displaylang=en
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx