Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question already has an answer here:

I have two database , dbOne(version - 10.50.1600 - locate in office server ) and dbTwo(version - 10.0.1600 - locate in my local server) .
I want to copy dbOne's tables with data to dbTwo .
Is there any way or script to do it ? I don't want to upgrade my local server-version !

share|improve this question

marked as duplicate by Paul White sql-server Dec 2 '15 at 5:59

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Here are several options you can try:

Export/import wizard: If you only want to copy tables and don’t want to bother with relationships and such this is probably the quickest way to do this.

Generate scripts wizard: Generate scripts for all tables you want to migrate. Right click on the database -> Tasks -> Generate scripts -> select only tables you want to migrate. Also make sure that you manually review execution order of scripts because SSMS doesn’t order these correctly be default (doesn’t take dependencies into account)

Third party tools: There are many database comparison tools out there you can use for this such as Red-Gate’s SQL Compare, ApexSQL Diff and many others…. All of these are premium tools but you can get the job done in trial mode.

share|improve this answer

Natively, if the database is small then Import/Export works fine.

For large database, BCP out and BCP IN is the a good way - fast and efficient.

See my answer and the script http://dba.stackexchange.com/a/43232/8783

share|improve this answer

If you have tcp connectin between two databases you can make linked serve.
then you can query your table on onther server.
in SQL MGM studio under object explorer there art node for linked servers. You can easly add one. after that you can do something like

insert into tableone. lsect * from [linked server].sorucedatabse.dbo.tableone

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.