John,

You could use a one-time snapshot replication between the two database tables to get the structure and data.

Or you could use DTS which maybe simplier if you only want to get the data.

Mike A.

>How can we copy tables & and or table structures from one database to another.
>
>Both database have the same name.
>
>Thanks in advance,
>
>John