var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL7 Table Copy DB1 to DB2 Same Server
Can you please advise on how to copy tables from DB1 to DB2 on the same SQL 7 Server. The programer had me drop the tables from DB2 and wants me to copy the tables from DB1 to DB2.
Thanks for any help.
/* if you have not created target table */
select * into DB1.OWNER.TABLENAME
/* if you have already created target table */
select * from DB2.OWNER.TABLENAME
be aware thar
Select * into DB2..<table Name>
creates copy of table without indexes, PK identity columns triggers..
Just use a DTS task to copy the table with its respective indexes, it'll do the trick
Thanks - DTS
Thanks for the referal to DTS. I was able to review the documentation and perform the copy.