Tool to transfer data among SQL Servers
Since I have no bulk read and write permission to my SQL Server database at my previous hosting plan, I can not use SQL Server data import/export tool to transfer my data to my new hosting database server. I spent a few nights and developed a small tool that connects to any sql server using OLE DB, fetch all tables in the database, and fetch all data from any table page by page. Based on this function, I have successfully implemented the tool to transfer any amount of data between two remote sql servers. The tool can not solve one problems so far. If any field is auto increase, the backup may not succeed. The project has been uploaded to popfly. SQLViewer