I have an OpenEdge 10.2B06 database that is replicated. We are using OE Replication PLUS and make use of the replicated database as our reporting database and run a couple of reports via CyberQuery connecting to the replicated DB via ODBC.
We have run into the age-old SQL Field width issue and now I am unsure if I need to run the field width adjustment utility on the target only or should I run it on the source and hope it replicates? Anyone done this before? What are your suggestions?
Thanks in advance
You just need to update your source and let Replication take over. We have this issue now and then as well, as our users have Crystal Reports
What about the new 11.6 feature Autonomous Schema Update?
Will this work when it's enabled on the target database where the queries are executed?
I very much like the idea of having an option to generate DDL instead of immediately applying it. That would permit a nice opportunity to review it first and even possibly distribute it to multiple parties.
Although Tom's idea of having an option to generate DDL is interesting, for this specific case I prefer immediately applying the change. Reason is that the application is accepting any data (most is coming via batch processes) and the SQL queries are quite business critical.
Generating DDL script would be great.