<div>
1. I use Red Gate SQL Compare, but it's somewhat expensive<br />
2. Link (temporarily?) the online and offline databases and write queries.<br />
3. Create an Azure database and use its SQL Sync feature.<br />
4. <a href="https://code.msdn.microsoft.com/Database-SyncSQL-Server-e97d1208" rel="ugc nofollow">https://code.msdn.microsoft.com/Database-SyncSQL-Server-e97d1208</a><br />
5.Move data via import and export, then merge appropriately<br />
6. Other sync vendors: Idera, sqlaccessories.com, cloud-elements.com
</div>


<div>
dchristal: &nbsp;i need to achieve &nbsp;this using program logic.<br />
Can you give me some different logics to achieve &nbsp;this ?
</div>


<div>
I need to better understand what you want to happen:<br />
Do you want to update your local record?<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Update the online database with this information?<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Insert this as new information to the online database?<br />
<br />
which record to you want to prevail? the online version or your local version?<br />
Are you wanting to sync just one record or all of the records in both tables?
</div>


<div>
Scenario: <br />
<br />
System went offline while user doing &nbsp;transaction. So all the transactions went to offline database.<br />
System needs to sync all the offline records to online db once the connection is restore. what are the different ways to achieve this ?
</div>


<div>
<div class="content wysiwyg-content">
I have a sales record(s) in my SQL offline database<br />
<br />
sample record:<br />
Tran# &nbsp; &nbsp;Loc# &nbsp; &nbsp; &nbsp;Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Item# &nbsp; SaleAmt<br />
2345 &nbsp; &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20151205 &nbsp; &nbsp; &nbsp; 542 &nbsp; &nbsp; &nbsp; &nbsp; 250.00<br />
<br />
<br />
How do i &nbsp;sync this record to online DB ? &nbsp;please provide me 3 to 4 different methods
</div>
</div>


I have a sales record(s) in my SQL offline database

sample record:
Tran#    Loc#      Date                Item#   SaleAmt
2345      5            20151205       542         250.00


How do i  sync this record to online DB ?  please provide me 3 to 4 different methods

How to  sysnc the record from offline to online database ?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.