469,310 Members | 2,750 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,310 developers. It's quick & easy.

Transfering data from SQL Server Standard to SQL Server Express

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,
Feb 28 '08 #1
1 1284
(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
Feb 28 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by bernardpace | last post: by
2 posts views Thread by Piotr Karwatka | last post: by
14 posts views Thread by Developer | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.