var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Merging 3 SQL Server databases into one.
How do I merge three SQL Server databases into one. There will be some duplicated information in some of the tables. Any help much appreciated. Thanks.
P.S. Running SQL v7 on NT!!
A very general question for what is going to be a very complex task.
Your primary concern will be Primary Keys. Are they duplicated across the databases (probably, unless you used GUIDs)?
Your secondary concern will be Natural Keys. Duplicated natural keys will need to be collapsed, along with all child records.