Make a copy of a database structure without the data?

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

Guest

I know that somewhere there is a way to make a copy of an entire database's
structure without any of the data in it. I don't want to copy and paste a
database or a database object. I just want the whole database but without the
data in it. I have done this before but can't remember where!!
 
JKB said:
I know that somewhere there is a way to make a copy of an entire database's
structure without any of the data in it. I don't want to copy and paste a
database or a database object. I just want the whole database but without the
data in it. I have done this before but can't remember where!!
Click to expand...

Create a new blank file and import into it all the objects in your current file.
There is an option for importing "structure only" for the tables.
 
1. Open the blank database.
2. File | Get External Data | Import and then browse to your other file.
3. On each tab press the Select All button to bring over all the objects.
4. Click the Options button.
5. Put a check next to Relationships and Menus And Toolbars.
6. On the Import Tables area select the option called "Definition Only" to not bring any data.
7. Press the OK button to bring everything into the new database.
8. Immediately compile your database (Debug | Compile)
9. Set any Startup properties, if any, in the new database.
10. Compact your database.

Bada bing, you're all set!
 
Back
Top