Thursday, September 20, 2012 10:54 PM
Compact database data transfer to Azure. Powershell, SSIS, SQLCMD?
Is there a simple solution to move sets of data from compact SQL to Azure without using RDA or sync? I was hoping to simplify the process of regularly moving X rows of data in one direction only.
We are developing a Windows tablet app using compact and transferring to Azure. If it were up to me I would install SQL Server and create a stored procedure to move the data.
Monday, September 24, 2012 6:17 AMModerator
According to your description, maybe you can try to use Erik’s scripting utilities for SQL Server Compact which includes a single new feature: Script Schema and Data for SQL Azure. This new feature allows you to migrate your SQL Server Compact solution to a SQL Azure database. For more details, please refer to Erik’s blog: New release of ExportSqlCe SSMS add-in and command line utilities-Script to SQL Azure. You can download the scripting utilities from here.
- Marked As Answer by Shulei ChenModerator Friday, September 28, 2012 7:59 AM