How to copy whole database

[Frank M.]

If you copy individial tables from one database to
another or within the same database you get the option to
copy structure or structure and data.
Now, how do you copy a whole database to a new name and
retain tables, queries, import definitions, etc. - but
without any data?


Regards,

Frank M.

 

[Joseph Meehan]

Copy the database to a new location, change the name and delete the
data.

 

[Frank M.]

yes, that of course works, but is not what I am looking
for. If it is a big database, deleting takes quite some
time.

I am sure that I have seen a way to copy just structure
and importdefinitions, just don't know the way.

Frank

 

[Rick Brandt]

yes, that of course works, but is not what I am looking
for. If it is a big database, deleting takes quite some
time.

I am sure that I have seen a way to copy just structure
and importdefinitions, just don't know the way.

Create a new empty file and import all of the objects from the original.
In the import options you can specify that you want table definitions only,
no data.

 

[Frank M.]

Thanks.

Frank M.

-----Original Message-----


Create a new empty file and import all of the objects from the original.
In the import options you can specify that you want table definitions only,
no data.



--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.