Transfer tables
Transfer tables with Data from on database to another one on a same server ,need assistance ? 
July 4th, 2015 4:46am

how to generate a script:

  • Right-click on the database name, then select "Tasks" then click on "Generate Scripts". After that, the Script Wizard opens. Click on "Next".
  • Select the Database you want to script.
  • Choose the object types. Click on "Next".
  • Select the tables.
  • Select the Output option for the script.
  • Change/Edit the database name to the name you want to execute this script for.
Free Windows Admin Tool Kit Click here and download it now
July 4th, 2015 4:52am

please provide more details - do you just need tables or data? do you need all indexes /constraints along with the tables

you best bet to cover all scenerios and if you do not want data  is to generate scripts

right clicck on the database(source) in the object explorer -Taks -- generate scripts -- list all the tables and choose all the tables you need and in the advanced - you can choose what all you need to be scripted..

you can also use ssis package

July 4th, 2015 4:55am

Select * into DestinationDB.dbo.tableName from SourceDB.dbo.SourceTable
This command only copies the table schema and data.
Free Windows Admin Tool Kit Click here and download it now
July 4th, 2015 5:01am

Follow the picture below :
Step 1 Go to SSMS ....

Step 2 : Select Data source 

Go to next reply (more then 2 image not allowed)

July 4th, 2015 3:32pm

step 3 : Chose destination Data source

Step 4: Select tables need to transfer with data

Go to next reply (more then 2 image not allowed)

Free Windows Admin Tool Kit Click here and download it now
July 4th, 2015 3:33pm

Step 5: Select data copy or move

Step 6: Process going on 

End

Hope 6 step  will be helpful  

July 4th, 2015 3:34pm

You can also use integration service .
Free Windows Admin Tool Kit Click here and download it now
July 4th, 2015 4:29pm

Third party tools:

There are many database comparison tools out there you can use for this such as Red-Gates SQL Compare, ApexSQL Diff and many others.

Red-Gate is very useful.You can try trail edition.

July 4th, 2015 10:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics