Merge Database - Revision history

Amy at 22:45, 14 October 2014

2014-10-14T22:45:13Z

Coryc at 16:51, 14 July 2014

2014-07-14T16:51:39Z

Marks at 23:31, 5 August 2011

2011-08-05T23:31:46Z

Marks at 23:30, 5 August 2011

2011-08-05T23:30:53Z

Marks at 23:29, 5 August 2011

2011-08-05T23:29:54Z

Marks at 23:27, 5 August 2011

2011-08-05T23:27:44Z

Marks at 22:42, 5 August 2011

2011-08-05T22:42:28Z

Show changes

Marks: Created page with "Title: SME Merge Databases Subject: Instructions of how to Merge SME databases. SME has the capability to merge databases. For example if you have database on an outside se..."

2011-08-05T22:40:16Z

Created page with "Title: SME Merge Databases Subject: Instructions of how to Merge SME databases. SME has the capability to merge databases. For example if you have database on an outside se..."

New page

Title: SME Merge Databases

Subject: Instructions of how to Merge SME databases.

SME has the capability to merge databases. For example if you have database on an outside server that needs to merge into an inside server, the SME merge capability will manage this.

Please note that lots of data is transferring for merge functionality and it’s not reversible or undo-able. It’s critical to have backups of both databases prior to doing the merge.

For purposes of this instructions we will consider an Outside database called OutsideDB that will be merged into an Inside database called InsideDB. Your database names will be different.
Below is an example of merging OutsideDB into InsideDB. All new customers from the outside are copied into the inside. All matching customers from Outside and Inside are not touched. Any customers in Inside database only database are not touched.

Summary of steps: You need to get the OutsideDB attached to the SQL Server that the InsideDB is running on. Once you attach the OutsideDB to the Inside SQL Server, then it is ready for the merge.

Steps:
1. Note: Be sure to have backups, especially of the InsideDB.
2. From the outside SQL Server, get a copy of the database files. There are two ways to do this: either make a backup or detach the database from the Outside SQL Server make copies and then reattach.
a. Option 1, Backup method: From SQL Management Studio on the Outside SQL Sever, select the OutsideDB, right click and select backup. Select the location to save the backup.
b. Option 2, Detach method: From SQL Management Studio on the Outside SQL Server, select OutsideDB and right click and select detach and follow the instructions to detach. Then make copies of the OutsideDB.mdf and OutsideDB_log.ldf files.
3. Copy the files created from step 2 to the Inside server.
4. From the inside SQL Server, run SQL Management studio so you can attach OutsideDB to this SQL Server instance.
a. Option1, Backup method from step 2: Right click on the database and select Restore. Select the backup file from step 3 to restore and follow the instructions.
b. Option 2, Detach method from step 2: Right click on the database and select Attach. Select the files copied from step 3 and follow the instructions.
5. You are now ready to merge.
6. Run SME on the Inside server. Select InsideDB. It’s important to run SME on the database that is going to be merged into.
7. Select Utilities>Utilities>Import Data
8. Select Merge from Database and select run it.
9. Select OutsideDB and select Ok to start the merge.
10. When the merge is completed, you can detach the OutsideDB from the inside sql server as follows:
a. Within SQL Management Studio, right click on the OutsideDB and select detach and follow the instructions.

@@ Line 100: / Line 100: @@
 <p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>9.<span
 style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Select
-OutsideDB and select Ok to start the merge.
+OutsideDB and select Ok to start the merge.</p>
 <p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>10.<span

← Older revision		Revision as of 16:51, 14 July 2014
Line 30:		Line 30:
	touched.</p>		touched.</p>

−	~~PUT picture here~~

@@ Line 19: / Line 19: @@
 <p class=MsoNoSpacing>&nbsp;</p>
-<p class=MsoNoSpacing><span style='position:absolute;z-index:251658240;
+<p class=MsoNoSpacing>For
 purposes of this instructions we will consider an Outside database called
 OutsideDB that will be merged into an Inside database called InsideDB.  Your
 database names will be different.</p>
-<p class=MsoNoSpacing><span style='position:absolute;z-index:251657216;
+<p class=MsoNoSpacing>Below
 is an example of merging OutsideDB into InsideDB.  All new customers from the
 outside are copied into the inside.  All matching customers from Outside and

@@ Line 20: / Line 20: @@
 <p class=MsoNoSpacing><span style='position:absolute;z-index:251658240;
-margin-left:222px;margin-top:188px;width:96px;height:88px'><img width=96
+margin-left:222px;margin-top:188px;width:96px;height:88px'>For
 purposes of this instructions we will consider an Outside database called
 OutsideDB that will be merged into an Inside database called InsideDB.  Your
@@ Line 27: / Line 26: @@
 <p class=MsoNoSpacing><span style='position:absolute;z-index:251657216;
-margin-left:349px;margin-top:36px;width:198px;height:129px'><img width=198
+margin-left:349px;margin-top:36px;width:198px;height:129px'>Below
 is an example of merging OutsideDB into InsideDB.  All new customers from the
 outside are copied into the inside.  All matching customers from Outside and

@@ Line 106: / Line 106: @@
 <p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>9.<span
 style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Select
-OutsideDB and select Ok to start the merge.<img width=624 height=300
+OutsideDB and select Ok to start the merge.
 <p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>10.<span

@@ Line 35: / Line 35: @@
 touched.</p>
-<p class=MsoNoSpacing>&nbsp;</p>
+PUT picture here
 <p class=MsoNoSpacing>Summary of steps:  You need to get the OutsideDB attached