Export database and tables no table data
-
Trying to move a database from one sql server instance to another on separate servers .
I need to only move it like a skeleton no data and looking for steps to export the database and tables.
Is this possible?
-
Why not just script out all the objects and then run all that in a separate database?
Otherwise, you could make a copy of your database and then use dynamic SQL to truncate all of the tables.
-
In SSMS object explorer, rightclick your database name, click "tasks", select "Generate Scripts"
next
Script entire database and objects ( is by default without the data )
advanced
make sure you script all options you want to ( by default it will e.g. not script triggers etc )
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
DBATools is awesome for this: Invoke-DbaDbClone
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply