Take the 2-minute tour ×
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.

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

closed as too localized by Mark Storey-Smith, dezso, Paul White, Max Vernon, StanleyJohns Jun 24 '13 at 18:05

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
Have you tried the Import/Export Wizard through SSMS? –  Shawn Melton Jun 24 '13 at 5:27
    
thanks you Shawn Melton , I used Import/Export Wizard and now It's work :) –  Robert Bellamy Jun 24 '13 at 5:37

3 Answers 3

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.