Got it, not free. How frustrating.
Main Topics
Browse All TopicsI'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.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership
by: Mortaza_doulatyPosted on 2008-12-22 at 22:53:00ID: 23231753
You can use Standard/Developer/Enterpr ise editions, which are not free.
qlserver/2 005/en/us/ how-to- buy .aspx
natively, 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). com/produc ts/SQL_Com pare/index .htm /www.red-g ate.com/pr oducts/SQL _Data_Comp are/index. htm
You should buy a license.
You can find about purchasing SQL Server licenses here:
http://www.microsoft.com/s
Alter
http://www.red-gate.
http:/
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)