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.
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
This command only copies the table schema and data.
Follow the picture below :
Step 1 Go to SSMS ....
Step 2 : Select Data source
Go to next reply (more then 2 image not allowed)
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)
Step 5: Select data copy or move
Step 6: Process going on
End
Hope 6 step will be helpful
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.