gsqlcmd Sync Sample


This sample shows different techniques to synchronize data across databases.

You may use it on any supported database platform.

This sample uses a database hosted on Microsoft SQL Azure Database.

You may install the sample into your SQL Server database using application-install.cmd from the setup folder.

See details in the gsqlcmd help (run: gsqlcmd help chm, then open Using gsqlcmd, Synchronizing Data).


You may use mssql-sample61-user1.xlsx to get sample data in Microsoft Excel.

You may install the SaveToDB add-in to edit data and save changes. See https://www.savetodb.com


1-sync-using-csv-to-table12.cmd requires the following permissions to use SET IDENTITY_INSERT:

GRANT ALTER ON s61.table12 TO sample61_user1;

Otherwise, it returns an error:

Cannot find the object "s61.table12" because it does not exist or you do not have permissions.

See details at https://docs.microsoft.com/en-us/sql/t-sql/statements/set-identity-insert-transact-sql?view=sql-server-2017



Copyright 2019-2025 Gartle LLC, https://www.gsqlcmd.com
