Project LID Homepage: Distributable Modules
LCCSQLAsyncTableReplication Homepage

Update 2/3/2020: Upgrade: updated USPs to allow 'MAX' query builds, was limited 4000 due to "EXEC sp_executesql", changed to not use "sp_executesql".

Update 10/2/2018: Document update: added Version Compatability codes.

Update 5/18/2018: Upgraded: downloads to temp table first, then to live table. This prevents live table from being deleted if download has issues.

Update 6/2/2017: Upgraded to support Linked Server connections

Update 5/24/2017: Upgraded USP lccDownloadTable to qualify table names that match system keywords on local replications, like 'TRAN'

Update 4/3/2017: Process Released


A database, set of SQL (TSQL) scripts (Stored Procedure) that enables replicating of tables from Remote or Local sources. The tables replicate asynchronously and do not require SSIS.

Each table processes separately and gracefully errors out only its process if an issue occurs.

Documents Application Files
The programs, scripts and documentation are provided AS IS without warranty of any kind. Lower Columbia College further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the programs, scripts and documentation remains with you. In no event shall Lower Columbia College, its authors, or anyone else involved in the creation, production, or delivery of the programs, scripts or documentation be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the programs, scripts or documentation, even if Lower Columbia College has been advised of the possibility of such damages.