How to copy DB 2007 without records

M

MaRSMAN

I would like to create a clean copy of my existing database without any of my
curremt records I have entered show up in the new copy.
 
B

Brendan Reynolds

MaRSMAN said:
I would like to create a clean copy of my existing database without any of
my
curremt records I have entered show up in the new copy.
Click to expand...


You can create a new, empty database and import the objects (tables, forms,
etc) from the existing database. In the 'Import Objects' dialog, click the
'Options' button to display some additional hidden options. In the 'Import
Tables' option group select 'Definition Only' to import the structure of
your tables without importing the data.
 
H

Heywould

you can generate scripts to recreate tables in a blank container by
right-clicking in SQL Server Management Studio
 
Top