Notifications
Announcements
No record found.
After importing the db from F&O tier2 to tier1 vm with sql package for about 10 minutes, I'm getting *** Error importing database:Could not import package. Warning SQL72035: [dbo].[CUSTINVOICEJOUR] is under change data capture control, but those settings will not be transferred [...] from several tables
Then the import fails. Tried different things to resolve with no success. Has anyone been able to resolve this?
Hi Lauri, I haven't faced this issue but did you tried disabling change data capture for CustInvoiceJour table or even at database level and exporting bacpac?
learn.microsoft.com/.../enable-and-disable-change-data-capture-sql-server
Hi Lauri,
I haven't tried this, but I found an old thread that mentions the steps to import into Tier 1 environment.
(+) Import Azure SQL DB backup to Tier 1 environment - Dynamics 365 Finance Forum Community Forum
Could please share the script you used importing the bacpac database?
Yes, .\SqlPackage.exe /a:import /sf:C:\Temp\backup.bacpac /tsn:localhost /tdn:AxDB_NEW /p:CommandTimeout=1200 /TargetTrustServerCertificate:True
Hello Lauri,
The import sometimes might not really work as expected at a go. I have also encountered similar errors. What I do, and propose is, rename the AxDB and re-import once again.
Have you tried it already? If not, do and let us know.
>> Hi Lauri, I haven't faced this issue but did you tried disabling change data capture for CustInvoiceJour table or even at database level and exporting bacpac?
We discussed about this with team, would it be too risky to take it off since the source environment is the UAT environment?
Since, it's UAT environment, you can disable it during off peak hours (Dark hours), export bacpac and enable it again.
Renaming the target database to just "NEW" resolved this issue. Thanks
Great. Glad you got it resolved.
I believe, you would have to rename the db NEW back to AxDB on the dev.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
