Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
moving large amounts of data from one db to another
0 views
Skip to first unread message
Smokey Grindel
Nov 23, 2009, 9:58:10 AM11/23/09
to
I have a table that has millions of rows of data in it, which then
references another table with millions of referenced (matching by foreign
key constraints)... I need to move this data from database A to a new
database B, is there any way to do this and preserve the identity columns
and their referential integrity?) Thanks!
references another table with millions of referenced (matching by foreign
key constraints)... I need to move this data from database A to a new
database B, is there any way to do this and preserve the identity columns
and their referential integrity?) Thanks!
Andrew J. Kelly
Nov 23, 2009, 10:52:17 AM11/23/09
to
You can't have integrated RI across databases so that part is out. But you
can certainly insert and keep the identities. Take a look at SET IDENTITY
INSERT in BOL.
can certainly insert and keep the identities. Take a look at SET IDENTITY
INSERT in BOL.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Smokey Grindel" <nos...@nospam.com> wrote in message
news:21185A4B-4FE2-4B90...@microsoft.com...
0 new messages