We have our BOs set up to point to the DT at the project level and also at the individual BO level. We have about 200 BOs. The types of the columns in SQL are all set to be 100 percent with the way Strataframe generates column types in Oracle. We also made sure that all our code was 100 percent compatible with Oracle.
I want to merely copy all tghe SQL project BOs over the existing Oracle BOs since we have made many changes and want a parallel Oracle BO Project.
My question here is on the Oracle Project after I copy the BO Project files from the SQL Server based BO Project over the Oracle BO project files using the same BO Mapper project:
1. Is there an easy way to just change to default at the project level to Oracle DB with the connect and then in a global step to change the default for each individual BO to point to the Oracle DB?
The tables names are identical. So I would not want to have to go in on each BO and configure it to select the table. No need to since the table and column names are indentical. If I could do this globally then all I would need to do would be to Generate the designer code for all 200 BOs for the entire Oracle Project, then set the global setting back to the DT and all of BOs back to the DT.
We only have a single BO Mapper and did not want to create a second one because setting the defaults in the mapper takes a long time and we realized the wizard to set the defaults still has a bug in it so that must be done 1 column at a time.
I know that this may not be the perfect way to go about handling both SQL Server and Oracle but this is the way we are doing it. If I have to go in each time and configure them separately it takes time.
If the answer to question 1 is to access the Strataframe configuration DB, what tables and columns would I need to change?