in

SQL Server Management Studio Express Import/Export

I've finished with a fairly large database that is ready to go into production. The database is built on SQL Server 2005 Express edition on a development server. I connect to the production SQL server and the developmen SQL server but neither offer me the option to import/export in the Tasks right click menu.

I have also search through this knowledge base and I can't find exactly what I am looking for. I understand that the import/export feature is not available in the 2005 Express edition of Management studio. I am looking for a link to download an edition that does have import/export.
Movie Stars

Solution: SQL Server Management Studio Express Import/Export

You can use Standard/Developer/Enterprise editions, which are not free.

You should buy a license.

You can find about purchasing SQL Server licenses here:
http://www.microsoft.com/sqlserver/2005/en/us/how-to-buy.aspx

Alternatively, you can use SQL Compare and SQL Data Compare softwares from RedGate (these are not freewares, but you can test trial versions and in 30 days, do what ever you need).
http://www.red-gate.com/products/SQL_Compare/index.htm
http://www.red-gate.com/products/SQL_Data_Compare/index.htm

SQL Compare if for comparing and making two databases the same (structures, tables, views, stored procedures, triggers and etc.)

SQL Data Compare is for comparing and making two databases with the same data. (Records)