>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