How to copy DB 2007 without records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
you can generate scripts to recreate tables in a blank container by
right-clicking in SQL Server Management Studio
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Split Assets db, issue moving to new directory 0
Record-Locking remains open after closing 0
removing blank records 4
Access Automatically Send a notification email once a record is added 0
copy table with records from one DB to other DB 2
Create an Access db template from an existing db (incl all objcts) 2
Copy Only Report or Query to Another DB 2
Database on Citrix Server 1

Back
Top