 |
A SQL Synchronizer is an essential tool for all developers specially if you are developing your SQL server (or SQL Server Express) based project from your Desktop and want to upload your SQL Server database (or SQL Server Express) to your remotely hosted website. If you are hosting your website to a shared environment, you face the first challenge from your hosting company and that is, 'Remote Connection to SQL Server is not allowed'; SpiceLogic developed a little SQL Synchronizer tool that will remove the restriction of 'Remote Connection is not allowed' imposed by your hosting company. It works both for SQL Server, attached SQL Server Express database and detached SQL Server Express file (*.mdf). Only one thing you must have is : 'A Windows hosting where you can run ASP.NET scripts, at least .NET Framework 2.0 with FULL TRUST configuration'. Usually, all other synchronization tools in the market do not support detached SQL Server Express database (*.mdf) file. But it is a very common need for a small project to use detached SQL Server Express database file. So, this tool will be the one for your need. When you are uploading your database from local to remote, you can select any SQL Server, SQL Express, Detached *.mdf file as a local database and provide the connection string to your remote SQL Server database and thats all. When you are downloading your remote database to local database, you wont even have to download to an existing SQL Server database. You can save the remote SQL server database to a new SQL Server Express detached *.mdf file. Special Synchronization feature: 'New Data Only'. If you choose this option, the program will check the identity column of your database tables and find out which rows was added to the table and synchronize accordingly. It can sync by Chunk so even if you have large database or slow internet connection, you wont face timeout problem or Maximum Request length limitation. Supports multiple database profiles.
|
