SQL Synchronizer for Remote Connection Restricted HostingOverview
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';. It is a frustrating limitation. What you gonna do !! You will create the same database in your hosting company provided control panel !! No way. If you are lucky because your hosting company provides you with myLittleAdmin ? well, in that case, you will have to go thru the following Steps: 1. Generate SQL Script for your database either from Visual Studio or SQL Server Administration tool like SQL Server Management Studio., 2. Open Internet Explorer, 3. Visit MyLittle Admin page, 4. Enter database name, user name, password, 5. click Tools, 6. Select new Query, 7. Paste the SQL Script in the Query pad and 8. Run the query. Dont tell me that you LOVE to do these everytime whenever you change a single column in a table or adda single row in a table in your database and want to synchronize it with the remote server. What about the situation when your database size grows. You will be stucked when you have heavy amount of data. Your MyLittleAdmin website will stop you uploading a very big size file by 'Time Out Error'. Aren't you frustrated ? Have you got a slow internet connection ? Oh, then, dont even try using MyLittleAdmin website. You will be timed out even for uploading a small size database sql script to your server.
NEW
Fixed some bugs.
SQL Synchronizer for Remote Connection Restricted HostingInformation