This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 43%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
I currently have a database that has ledger enabled, and ran into problems when using EFCore migrations with this feature enabled. I would now like to take the Azure Sql database with Ledger enabled and export it to a new database with ledger disabled.
Using SSMS 18.11.1, I am using the Deploy Database to Microsoft Azure Sql Database Task and everything seems to go well until it actually starts to import the first table:
It sits at this step for many minutes without any indication/message and feels like it's thrown an exception without indication to the user.
Maybe I am not waiting long enough? In any case, it would be ideal/appreciated to be able to get a ledger-enabled database to a non-ledger-enabled database. Any guidance would be appreciated.
An Azure relational database service.
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
Alright so in 18.10.x it hung for a very long time but with 18.11.1 it did finally complete with an exception. Looks like those ledger columns are tagging along for the ride. I am looking for a way to easily get my data from my ledger-enabled tables to my non-ledger-enabled tables. Any guidance/insight would be appreciated.
Hi @Mike-E-angelo , your solution is great. I change the comment into an answer and I fixed the "waiting for review" issue
Another option is to use bacpac and edit the package manually (same idea as in your solution
A bacpac file is actually a simple zip file which include simple files that you bcan edit manually
Check this recording for example: https://youtu.be/jakWrfzIZQE
Thank you for the reply @Ronen Ariely . Interesting you suggest this as I did look into bacpac's and stopped when I saw that there was a checksum on the model.xml file. I wasn't sure how that was calculated but was thinking there was some protection around modifying this file. I will see if I can set aside an hour to view that video. :P If you have a link/site that explains this further in detail that would be appreciated (and preferred).
Hi,
If you have a link/site that explains this further in detail that would be appreciated (and preferred).
The recording should cover it fully. It is not theory lecture but a practical one. I presented it a few events (might be small changes but the basic is the same) so there are recordings in English and Hebrew if you prefer :-)
Watching now @Ronen Ariely thank you for sharing!
Watching now @Ronen Ariely thank you for sharing!
You are most welcome :-)
----------
Ronen Ariely
Personal Site | Blog | Facebook | Linkedin
Since this post is still awaiting moderation (:P :P :P). What I ended up doing is:
Import Data... I also had to Enable Identity on columns for the generated SSIS package. I am not entirely sure the data is OK as I still have to deploy application code (Azure DevOps) but this got me moving so I can attend to the next fire.