karthik80c
asked on
How do i Copy All the Tables from One Database to Another in SQL Server?
Hi Experts,
We have created a new Database now want to move all the tables schema to the New Database , so is there any shortcut to do this on SQL Server.
Thanks in Advance
We have created a new Database now want to move all the tables schema to the New Database , so is there any shortcut to do this on SQL Server.
Thanks in Advance
If you have SQL Serer Data Tools (SSDT) available you can create a new database project, then do a schema compare between source db and empty target db, then execute all objects. This will create the schema but not move any data.
ASKER
sorry pal .I don't have the tool .can u give some query to do that and that would be great
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
oh OK thanks . let me try with the tool
Take backup of the existing database and restore it where you need.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks and Let me do this Pal