Import Order

Transact-SQL
1

Hi There,
I am trying to create a new database with a few extra pieces, which I have done without issue.
My problem is when I import the old records into the new database I get errors because certain data is missing and the records are reliant on them and they need to be imported first.
How do I find out which data is reliant on what?

Thanks for your help.

Best regards,

Steve.

2

this article should help

3

Are you not able to use backup/restore method?

4

I recently had this problem since my source db was 2012 and my target 2008 R2.