Copy structures from one db to another

  • Thread starter Thread starter kramer31
  • Start date Start date
K

kramer31

Hi. I have several related database models which have many of the
same structures (tables/queries/reports). I usually develop or change
some of those structures within one database and then copy them to the
other. The problem is that when I copy and paste them, I can't select
multiple structures at once. Also, when I paste them, it would be
nice if I didn't have to type the name again (or copy and paste the
name separately). I know this is a little bit picky, but it really
does take a lot of time.

Does anyone have any idea how to do this?
 
Hi. I have several related database models which have many of the
same structures (tables/queries/reports). I usually develop or change
some of those structures within one database and then copy them to the
other. The problem is that when I copy and paste them, I can't select
multiple structures at once. Also, when I paste them, it would be
nice if I didn't have to type the name again (or copy and paste the
name separately). I know this is a little bit picky, but it really
does take a lot of time.

Does anyone have any idea how to do this?
Click to expand...

Why not use:
File + Get External Data + Import ?
Navigate to the database you wish to copy.
Select all the objects you wish to import.
When you select the tables, click on Options and select
Definition only.
Click OK
 
Back
Top