Predelivered functions / sp to support Release copy backend code
In order to reach an end-to-end executable process as per Release copy feature, delivery consultants need a set of predelivered functions / stored procedures to support backend code promotion including:
Compare objects & ETL jobs of 2 releases (with optional filter to focus on “development area”, “source”, “dataset” only)
Returns excel import formats for template
Generates SQL scripts to promote custom objects to the new development area, code adjusted
Highlights missing dependencies, e.g., source tables
Log in to comment and vote
Comments4
John Munkberg
Mar 6
Team - there is no “Back End” to query against. The Back End is now in the cloud.
You should be using the DB Object Promotion screens in Migrate to review and promote your SQL Database objects from DEV to LOAD, or between Working Databases. This feature has extensive filtering and supports moving SQL code between databases (or schemas) on the same server, or between different servers.
It has a very robust interface for filtering, selecting, and migrating DB Objects.
If you have additional suggestion on how to improve this process - please let me know. But I won’t be proceeding this is idea of supporting back-end code promotion outside of the product.
Kevin McDonald
Mar 4
Hi Guillaume - thanks for the feedback. I’m putting this item into ‘Future Consideration’, as we already have begun working on some processes for implementing this in the platform.
Guillaume Dutey
Mar 4
if you’re interested, I can organize meetings with Delivery colleagues to contribute to this WIP. brainstorming, feedbacks, design workshops… just ask me!
Kevin McDonald
Mar 4
Awesome - we might want to find some time with John M to review these new screens/processes that he has put together.