Editing Merge Database

<p class=MsoNoSpacing><b>Title:  SME Merge Databases      </b></p>

<p class=MsoNoSpacing>&nbsp;</p>

<p class=MsoNoSpacing>Subject:  Instructions of how to Merge SME databases.</p>

<p class=MsoNoSpacing>&nbsp;</p>

<p class=MsoNoSpacing>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.</p>

<p class=MsoNoSpacing>&nbsp;</p>

<p class=MsoNoSpacing>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.</p>

<p class=MsoNoSpacing>&nbsp;</p>

<p class=MsoNoSpacing><span style='position:absolute;z-index:251658240;
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
database names will be different.</p>

<p class=MsoNoSpacing><span style='position:absolute;z-index:251657216;
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
Inside are not touched.  Any customers in Inside database only database are not
touched.</p>



<p class=MsoNoSpacing>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.</p>

<p class=MsoNoSpacing>&nbsp;</p>

<p class=MsoNoSpacing>Steps:</p>

<p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>1.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Note:
Be sure to have backups, especially of the InsideDB.</p>

<p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>2.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>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.</p>

<p class=MsoNoSpacing style='margin-left:1.0in;text-indent:-.25in'>a.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>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.</p>

<p class=MsoNoSpacing style='margin-left:1.0in;text-indent:-.25in'>b.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>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.</p>

<p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>3.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Copy
the files created from step 2 to the Inside server.</p>

<p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>4.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>From
the inside SQL Server, run SQL Management studio so you can attach OutsideDB to
this SQL Server instance.</p>

<p class=MsoNoSpacing style='margin-left:1.0in;text-indent:-.25in'>a.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>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.</p>

<p class=MsoNoSpacing style='margin-left:1.0in;text-indent:-.25in'>b.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>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.</p>

<p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>5.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>You
are now ready to merge.</p>

<p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>6.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Run
SME on the Inside server.  Select InsideDB.  It’s important to run SME on the
database that is going to be merged into.</p>

<p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>7.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Select
Utilities&gt;Utilities&gt;Import Data</p>

<p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>8.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Select
Merge from Database and select run it.</p>

<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.</p>

<p class=MsoNoSpacing style='margin-left:.5in;text-indent:-.25in'>10.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp; </span>When the merge is
completed, you can detach the OutsideDB from the inside sql server as follows:</p>

<p class=MsoNoSpacing style='margin-left:1.0in;text-indent:-.25in'>a.<span
style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>Within
SQL Management Studio, right click on the OutsideDB and select detach and
follow the instructions.</p>