Copy structures from one db to another

[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?

 

[fredg]

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?

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