>>>>>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.
>
>Thank you. I will try this approach. Creating indexes I can do "manually" as long as all records are replicated in the second DB.
Yes they would be. This is like doing "copy to" in VFP.