Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Compact database data transfer

Answered Compact database data transfer

  • Thursday, September 20, 2012 10:54 PM
     
     
    Sign In to Vote
    0

    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.

    Thank you,

    Jim Traub

     

All Replies

  • Monday, September 24, 2012 6:17 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Jim,

    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.


    Best Regards,
    Ray Chen