How to merge databases?

Article View: bit.databases.mssql-l

Article #84

Back to bit.databases.mssql-l Previous Next

#84

From: Dave A. Law
Date: Sun, 07 May 2000 00:00

16 lines
1320 bytes

I need some advice about merging two databases using MS SQL Server
7.0.  The database structures are exactly the same in the two, just
the data may be different.  However, because of referential integrity
I have to merge the data in a very specific order.  For various
reasons dropping referential integrity is not possible.  While I could
manually spend a number of hours and determine the order the tables
have to be populated, I was wondering if there might be a query I
could create using system tables to determine the order.  Anyone who
has any advice, sql examples, or anything else that might help I would
appreciate if you could e-mail me at: dave.law@hedgehogsystems.com

Thanks.

- Dave
  Software Developer/Systems Analyst
  Hedgehog Systems Inc.

Technical Details

Message-ID: <3914dc59.736139@news.cadvision.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,4f3d754293f8b3c,start
X-Google-Attributes: gidf6611,public
From: lawd@cadvision.com (Dave A. Law)
Subject: How to merge databases?
Date: 2000/05/07
Message-ID: <3914dc59.736139@news.cadvision.com>
X-Deja-AN: 620155159
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 204.50.1.43
Content-Type: text/plain; charset=us-ascii
X-Trace: 6 May 2000 20:58:46 -0700, 207.148.143.101
Organization: DEGA Studios
MIME-Version: 1.0
Newsgroups: bit.databases.mssql-l