Hi all,
I have a business layer which is pointing to a multi-source data foundation. I want to point this business layer to a single-source data foundation.
It is easy to re-point a BL to a different data foundation but then the problem is the syntax of the select in the SQL definition. For a multi-source data foundation the syntax is: "schema"."table"."object". For a single-source data foundation the syntax is: table.object without schema and without inverted commas "".
Is there an easy way to change all the objects' SQL definition in the BL without going one by one?
Thanks.
I haven't tried to replace multisource DF to single source but if you have concern on double quotes only then you can use Find/Replace function in Business layer to replace " with one blank space.
Hi,
I afraid there is no easy/automatic way to map existing BL objects to the new Data foundation
Reference to the old connection does not get replaced with new one within existing BL.
Try creating a new BL with in the same project and pull in objects from New DF or drag and drop new DF table columns into same BL class folder ( you should see "Name1" if there is a duplicate column names with in BL), Change the description accordingly.
Just providing my view by experience. you can wait for others to reply.
Thanks,
Jothi