Mappings
nwohater
Posts: 2
Hi,
We have some applications that use some stored procedures to read/write data to our JD Edwards environment. I see how you can map schema/owner but in this particular case the database name will vary by environment. For example:
JDE test environment: JDE_PY.CRPDTA.Tablename
JDE prod environment: JDE_PROD.PRODDTA.Tablename
Is there any way to change the database name and schema/owner when using SQL Compare to deploy changes?
Thanks
We have some applications that use some stored procedures to read/write data to our JD Edwards environment. I see how you can map schema/owner but in this particular case the database name will vary by environment. For example:
JDE test environment: JDE_PY.CRPDTA.Tablename
JDE prod environment: JDE_PROD.PRODDTA.Tablename
Is there any way to change the database name and schema/owner when using SQL Compare to deploy changes?
Thanks
Comments
Thanks for your query- this is just a copy paste of what I sent via email.
There is no way to do that programmatically, so you would have to manually set the mapping for each set of Sources and Targets. Once you set the mapping- you can save it in a project file allowing you to reuse it either in the GUI or command line- so you would never have to map it again.
You can always manually edit the scripts that SQL Compare outputs and that will allow you to make even more changes to how you want it deployed.
More info on mapping https://documentation.red-gate.com/disp ... nd+columns
More info on projects https://documentation.red-gate.com/disp ... h+projects
If there is something else that you do not see available in the tool- I suggest you post the idea in our UserVoice forum available here
https://redgate.uservoice.com/forums/141379-sql-compare
Hope you have a great weekend!
Warm Regards,
Technical Sales Engineer
Redgate Software