SQL Sync

Navigation

• Getting Started
• Concepts
• FAQ
• Tests
• Future Improvements
• SyncTable: Type-1 copies
• DiffTable: Type-2 copies
• How to Get Support
• License: Apache 2.0

You're an BI engineer, developer, or DBA who has a lot of tables/data to move around in SQL Server. You want to copy the data and assign surrogate keys, and identify what's new, or has changed. This is one of the oldest ETL problems around: extraction.

To install, download this codebase, and run all the .sql files in the root directory. Run the SQL files in the database where you want to store this code.

The SQL Sync utility runs on:

• SQL Server 2008, 2008R2, 2012, 2014, 2016 - yes, fully compatible
• SQL Server 2017 - probably compatible, but hasn't been tested yet
• SQL Server 2000, 2005 - not supported by Microsoft anymore, so we don't either
• Amazon RDS SQL Server - not sure yet.
• Azure SQL DB - not sure yet.

Getting Started

See the Getting Started Guide.

How to Get Support

Everyone here is expected to abide by the Contributor Covenant Code of Conduct.

Got a question? Email us at [email protected].

Want to contribute by writing, testing, or documenting code, or suggesting a new check? Read the contributor.md file.

Back to top

Concepts

See the Concepts page

Back to top

FAQ

See the FAQ

Back to top

Future Improvements

See Future Improvements

Back to top

Tests

See Tests.

License

The SQL Sync utility uses the Apache 2.0 License.

Back to top