none
Using Web Deploy to migrate a large SQL Compact Database to a SQL Server Database

    Question

  • I've been trying to use the API provided by Web Deploy to transfer a SQL Server Compact database to a SQL Server database. This seems to work fine, until I try to use a SQL Server CE database file larger than the default size limit (256MB), in which case I get one of two errors.

    If I don't specify the max database size in my connection string:

    The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [ Required Max Database Size (in MB; 0 if unknown) = 0 ]

    If I define it, I get:

    Keyword not supported: 'max database size'.

    This seems like a straight up bug with Web Deploy, but I thought I could get around it by creating a connection first to "initialize" the max database size, as this blogpost hints at, to no avail.

    Is there any way I can use Web Deploy for migrating large SQL Compact databases to SQL Server?

    Friday, February 10, 2017 10:06 PM

All replies

  • Use my scripting api/comand line tools instead: https://stackoverflow.com/questions/44552049/programmatically-script-or-migrate-sql-compact-database-for-importing-into-sql-s/44552538#44552538

    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    Thursday, June 15, 2017 6:39 AM
    Moderator