cancel
Showing results for 
Search instead for 
Did you mean: 
marcpaige
Cosmonaut
Status: New

Often, I have experimental tables, MVs, etc. in my development tenant. To keep production clean, these are not migrated through a schema export. I have to hand move the production adds and changes from dev to prod. 

It would be very useful to have a dialog to allow the selection of schema objects to export.

2 Comments
LayeredDelay
Employee
Employee

@marcpaige I think you are saying you would like to export certain table level objects or MVs from a schema. So if I had a schema called "Data" and it had 10 tables and 5 MVs, you might want to say export Data but only bring in Table 1, 2, 3, 7, 8, 9 and MV 2, 3. Is that correct? Where this can get tricky is if you have dependencies between objects. You could have a formula column in table 8 that is dependent on table 6 which was not included. You wouldn't pick up on that until after deploying in the production schema. Same goes for joins that you might define. Let me think about this some more and see how we could help with this in the future. Thanks for sharing your insight and we might well be in touch to share more later or get some additional information. Adding @awarrier to this discussion so we can capture everything. 

marcpaige
Cosmonaut

Yes, you are correct in your interpretation. I realize this is a bazooka of a tool and using it would require care and knowledge of the schema and its dependencies.