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
Microsoft SQL ServerMicrosoft SQL Server 2005
Last Comment
karthik80c
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks and Let me do this Pal