What are the challenges you face when working across database platforms? Take the survey


nwohaternwohater Posts: 2
edited March 19, 2016 12:21AM in SQL Compare 11

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?



Sign In or Register to comment.