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?

Answer 1

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)

Answer 2

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.

Answer 3

@Portman SqlDataCompare does not actually sync data, but only compares objects / mappings - am I correct, or am I missing something? great tools, thanks for the link