开发者

Convert SQLCE database to SQL Server 2008 with WebMatrix when database size > 256Mb

开发者 https://www.devze.com 2023-04-13 05:52 出处:网络
I have a website with a SQLCE database which has grown to around 500Mb.There were errors with the website when the database exceeded 256Mb, which were circumvented by applying \'Max Database Size = 10

I have a website with a SQLCE database which has grown to around 500Mb. There were errors with the website when the database exceeded 256Mb, which were circumvented by applying 'Max Database Size = 1024' to the connection string in web.config. Fine for now.

However, I'd like a more robust database going forward, so I want to convert to SQL Server 2008 Express. Normally this is possible in WebMatrix (and I think in Visual Web Developer 2010 Express too) but on this occasion neither WebMatrix nor Visual Web Developer are able to access the database to publish it because they're both getting file size errors, which must be related to the way those programmes access the SQLCE database.

Does anyone know how to either increase Web Matrix or Web Developer Express' permitted SQLCE database size, or is there another tool which 100% robustly converts larger SQLCE databases to full MS开发者_高级运维SQL?

Thanks!


It is only possible in WebMatrix, not VS Web Dev Express. Suggest you try my Exportsqlce command line utility, it has been tested with large(ish) database files. And if it does not work, I will make it! http://exportsqlce.codeplex.com

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号