sqlserver express database copy options

Question

Why can I not see an option for copying database objects when I right click > tasks on my database?

dpollock · Accepted Answer · 2008-09-16 11:33:22Z

2

MS Sql Server Express doesn't come with SSIS which is what you will need to import/export objects out of your database.

You can also manually script this process. One way is to use BCP (http://msdn.microsoft.com/en-us/library/ms162802.aspx)

answered Sep 16, 2008 at 11:33

dpollock

1751 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Agreed. The Import and Export options require a for-pay edition like Standard or better.

Portman · Accepted Answer · 2008-09-16 13:01:08Z

0

Have a look at Red Gate SQL Compare and SQL Data Compare.

You can download the trial and use them to build a script that will dump your objects to a .sql file.

answered Sep 16, 2008 at 13:01

Portman

32k25 gold badges84 silver badges101 bronze badges