November 18, 2024 at 3:22 pm
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?
November 18, 2024 at 4:40 pm
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.
November 19, 2024 at 9:15 am
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
November 21, 2024 at 4:35 pm
DBATools is awesome for this: Invoke-DbaDbClone
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy