>>>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
>>
>
>First, thank you. And even PK fields will have the same values?
Yes. With this approach, initially there isn't even a primary key set. You can use alter commands and create index ... It might need more scripts depending on what exactly you want to achieve.