sampurngupta44

🔄 RowSync - Sync your database rows with ease

🎯 What is RowSync?

RowSync helps you move data between SQL Server databases. You select rows from your production system and copy them to your development, staging, or local environments. You see a preview of your data before you perform the update. This tool handles the update process so you do not need to write manual scripts. It works in offline settings and provides status updates while it runs. RowSync connects directly to your databases and ensures your data stays consistent across different environments.

💻 System Requirements

RowSync runs on Windows computers. Ensure your system meets these requirements before you start:

• Windows 10 or Windows 11.
• An active connection to the SQL Server databases you want to sync.
• Your user account needs permission to read data from the source and update data in the destination.
• At least 200 MB of free hard drive space.
• The Microsoft ODBC Driver for SQL Server. If you do not have this, the application will provide a link to download it during the setup process.

🚀 Setting Up the Application

Follow these steps to install and start RowSync on your machine:

1. Visit the official GitHub release page to find the latest version of the application.
2. Locate the file ending in .exe in the “Assets” section.
3. Click the file name to start your download.
4. Once the file finishes downloading, double-click the file to start the installer.
5. Follow the prompts on your screen to complete the installation.
6. Launch RowSync from your desktop icon or the Start menu.

⚙️ Connecting to Databases

You must connect RowSync to your source and destination servers before you move data. RowSync stores your settings locally on your computer to keep your data private.

1. Open the application.
2. Click the “Settings” tab in the top navigation bar.
3. Enter your “Source Database” details. Provide the server address, your user name, and your password.
4. Enter your “Destination Database” details using the same method.
5. Click the “Test Connection” button for each database to ensure the path works.
6. Click “Save” to keep these settings for your next session.

📋 Running a Data Sync

RowSync follows a three-step process to move your data safely.

Step 1: Select Your Data

Use the Query Builder tab to write your request. You can type standard SQL commands here. The application provides an autocomplete feature to help you choose table names and column names. Type your command and click “Run Query” to fetch the rows from your production server.

Step 2: Preview the Results

The application displays the rows you selected in a grid format. Review this list. Check the columns and data types to ensure you have the correct information. You can remove specific rows from your selection by unchecking the boxes next to each row.

Step 3: Perform the Update

Click the “Sync to Destination” button. The application starts the process. You will see a progress bar that updates in real time. RowSync will automatically map the selected rows to your destination table. If a record already exists, RowSync updates the values. If the record does not exist, RowSync adds it to the target database.

🛡️ Privacy and Ownership

RowSync operates in an offline-first mode. This means your data travels directly from your source server to your destination server. The application does not send your data to any external cloud services or third-party servers. All SQL queries and connection strings remain on your local hard drive. Use this tool with confidence knowing that your sensitive production data stays within your local network or environment.

🔧 Troubleshooting

If you encounter issues while using RowSync, check these common items:

• Does your computer have a connection to the network? RowSync requires network access to talk to your SQL Servers.
• Do you have the correct network permissions? Your database admin must grant you access to the specific tables you want to sync.
• Is your SQL Server running? If the service is down, RowSync cannot fetch your data.
• If you see an error about a missing driver, visit the official Microsoft website and install the ODBC driver for SQL Server.

📖 Frequently Asked Questions

Can I sync data between different versions of SQL Server? Yes. RowSync handles connections to various versions of SQL Server.

Does RowSync delete rows in the destination? No. RowSync only adds new rows or updates existing ones. It never removes data from your destination database.

Can I stop a sync once it starts? Yes. You can click the “Cancel” button during the sync process. The application will stop the task at the current progress point.

Where does the application store my logs? RowSync keeps local log files in your user folder. Use these logs if you need to debug a failed sync attempt. Open the “Help” menu to find the location of these files.

💡 Best Practices

Use these tips to get the best results with RowSync:

• Always back up your destination database before you run a sync.
• Limit your select queries to the specific rows you need to move. This improves performance.
• Use the preview window to verify your selection before you start the update.
• Keep your application version updated to receive the latest improvements and bug fixes.