Replicate structure only
-
Wednesday, April 26, 2006 3:25 PM
I have a db and I only really need the table structures and defined functions/procedures from the db. A small sample set would be nice from each table, but not necessary.
What would be the easiest way to accomplish this?
I'm getting the db from a server not connected to the new one so I either need to get the files and reattach or I need to just copy the structure/procedures in.
thx
All Replies
-
Wednesday, April 26, 2006 8:12 PMModerator
If all you need is just object schemas, then it's probably easier to just script out the database objects and apply them to your db.
If you don't mind having the data as well, just create a database backup and restore to your machine.
.png)
