Is there a way to deploy Memory Optimized tables through source control?
Is there a way to deploy memory optimized tables through source control without solely using pre/post scripts and disabling the IncludeDependencies? Can this be done through, I guess what would be considered, typical source control processes?
Tagged:
Answers
Just to confirm, are you getting the error "DDL statements ALTER, DROP and CREATE inside user transactions are not supported with memory optimized tables" error?
This will occur if you have memory optimized tables and are using transactions. You should be able to get around this, however, by turning off transactions in the comparison options.
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?
My apologies, just to make sure I'm understanding correctly, can you please provide more detail on how the deployment fails if the memory optimized tables are included? What error does it fail with?
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?
Hi @scott1060,
Ah I see, just to confirm (and apologies if I'm still misunderstanding!), would the Comparison options>"Don't use transactions in deployments scripts" option be a suitable workaround?
Using that option, you would be able to include the memory optimized tables and dependencies in the repository, and do normal get latest/commits for them instead of via post scripts.
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?
You would need to apply the "no transactions" option wherever the SQL Compare engine is used, so this would include any build or release steps.
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?