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?