How to copy whole database

  • Thread starter Thread starter Frank M.
  • Start date Start date
F

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.
 
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
 
Frank M. said:
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.
Click to expand...

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.
 
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


.
Click to expand...
 
Back
Top