Hi are you looking to copy from Database 1 (has the data) to Datbase 2 (which is blank) but wish to retain the Parent/Child relationships?
If so then from Database 1 migrate the date:
[Code]
SET IDENTITY_INSERT YourDatabase2.dbo.YourTable ON
INSERT INTO [YourDatabase2].[dbo].[YourTable]
([Ident Column]
,[Field1]
,[etc....])
SELECT
IdentColumn,
Field1,
etc.......
FROM [YourDatabase1].[dbo].[YourTable]
SET IDENTITY_INSERT YourDatabase.dbo.YourTable OFF
[/Code]
Repeat for the child table.
Hope I understood your issue correctly.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper