Thursday, January 03, 2013 12:12 PM
For a Multi-tenant SaaS solution hosted on a single SQL Server 2008 R2 instance (many db's and many clients per db). What is the best mechanism for a tenant to import and export data (say to a csv file on a local directory). Assume data migrations are small but frequency is high due to many users. Should I consider running an export through a Stored Procedure, SSIS or dynamic SQL through an ODBC or ADO data provider. The user interacts with the system through a web interface. It has been suggested that MVC and entity framework is the way to go.
Any and all comments are welcome.
Wednesday, January 09, 2013 6:14 AMModerator
For importing and exporting data to SQL Azure database, we always use Data-Tier Application Import and Export with SQL Azure (en-US). The import and export features provide the ability to retrieve and restore an entire database, including schema and data, in a single file operation.
In your scenario, I prefer using SSIS to import and export csv file.
TechNet Community Support
Thursday, January 10, 2013 11:32 AM
Many thanks for the reply and links.