ExportSqlCe40.exe Error Code: 80004005

[tuccero9]

Hello,
I executed the tool ExportSqlCe40.exe to convert a database running on SQL Compact Edition version 4.0.8482.1 but i receive an error code 80004005 with message "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]"

Do i need to set this "Max Database Size" somewhere?

This is the command that i executed:
ExportSqlCe40.exe "Data Source=C:\ProgramData\Access Control Technology\ACT Enterprise\Database\ACTEnterprise.sdf" ACTEnterprise.sql

I used "ExportSqlCE40.zip - SQL Compact 4.0 command line utility to generate a script with schema and data" release 3.5.2.
The server is running on Windows Server 2016 Datacenter.

Database engine: SQL Compact Edition version 4.0.8482.1

Let me know if you need to share some additional information.

[ErikEJ]

Set the max database size in the connection string: https://learn.microsoft.com/en-us/previous-versions/sql/compact/sql-server-compact-4.0/ew0d66d7(v=vs.100)

[tuccero9]

Thank you Erik. Worked like a charm! Stavros Tseriotis Infrastructure and Operations Department Officer Technology and Data Management Division Gr. Afxentiou 8, 1096 Nicosia T: +357 22743281 ***@***.*** From: "Erik Ejlskov Jensen" ***@***.***> To: "ErikEJ/SqlCeToolbox" ***@***.***> Cc: "Stavros Tseriotis" ***@***.***>, "Author" ***@***.***> Sent: Wednesday, November 1, 2023 11:36:26 AM Subject: Re: [ErikEJ/SqlCeToolbox] ExportSqlCe40.exe Error Code: 80004005 (Issue #971) !ΕΞΩΤΕΡΙΚΟΣ ΑΠΟΣΤΟΛΕΑΣ! Set the max database size in the connection string: https://learn.microsoft.com/en-us/previous-versions/sql/compact/sql-server-compact-4.0/ew0d66d7(v=vs.100) — Reply to this email directly, view it on GitHub , or unsubscribe . You are receiving this because you authored the thread. Message ID: <ErikEJ/SqlCeToolbox/issues/971/1788668389 @ github . com> «The information contained in this e-mail and any of its attachments are of a confidential nature and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient, you should immediately notify the sender by email and delete the message and all of its attachments. If you are not the intended recipient, you are notified that disclosure, dissemination, distribution, reproduction, copying or taking any action in reliance on the contents of this email and any of its attachments is strictly prohibited. This message cannot be guaranteed to be secure or error-free or delivered on time. The sender bears no responsibility for any virus, loss, disruption or any other damage caused to the sender by the content of this email»

[ErikEJ]

@tuccero9 Cool. Can't believe there are still users of this tool! 😅