Notifications
Announcements
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…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 629 Super User 2025 Season 2
Abhilash Warrier 444 Super User 2025 Season 2
BillurSamdancioglu 288 Most Valuable Professional
