>>Hi,
>>
>>Say I have two tables in a SQL Server database, Parent and Child.
>>I want to copy/duplicate these two tables in another database keeping all records with their PK values the same. So that the second copy of the tables (in a new DB) is exactly the same as in the first.
>>How do you do it?
>
>Connection having access to both databases you simply use select into:
>
>
>select * into targetDb..targetTable from sourceDb..sourceTable
>
That will work the first time, but if the target table exists, it will crash.
Offhand, don't know the the SQL syntax to test and delete if present, but that will make this OK.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.