Please help me with this query...
I could not get you completely, but I believe this is what you were looking for.
You are currently developing the .rpd in your development server, using DEV schema.
At a later point in time, you would push this .rpd to your test, where in, it has to pick tables from TEST schema.
If it so, in your physical layer of the .rpd, just change the physical schema to "TEST". It is the object which is just one level up to your tables in the physical layer.
Hope this helps.
Thanks for the reply.. let me put my question in this way...
In same RPD i have both TEST and DEV schema folders as below.
TEST schema -> table1,table2
DEV schema -> table_m,table_n
development is done with the above mentioned structure in physcial layer.
Now i have to move the tables table_m & table_n to TEST schema without making any cahnges to BMM. i cannot simply drag and drop the tables from DEV to TEST. is there a way to accomplish what i am looking for?
If i understand correctly, in the RPD @ TEST environment, table_m and _n should be used instead 1 and 2. am i correct?
Are you using aliasing concept in physical layer? if yes, change the source of the alias in the physical layer to the new tables in TEST schema.
Thanks for the reply...
just a small correction there.. the tables table_m and table_n are not alisases. just want to move them so that i have all the 4 tables in TEST..
TEST Schema -> table1,table2,table_m and table_n
I was just trying to understand the rationale behind moving these tables. As I understand, if you are trying to move these objects into test schema
1. You might want to make changes in the physical model as well, which might impact the business model ultimately.
2. You might not have the DEV schema itself in your test environment.
3. You might already have had some physical foreign keys across schemas.
Anyway, I am just inclined to think, that moving tables might need at least some minimal modifications in BMM. But, how about a smart view of doing it; Just rename the existing DEV schema to TEST and continue. Let me know, if you could try it.
Thanks for the reply Dhar..
The issue with renaming is I have both Test and Dev schema folders in rpd. Half the tables in dev and half the tables in test... So I can cut and paste the tables from one schema to other but as u mentioned I may have to do some changes in physical and bmm layer since I have alias tables and foreign key defined across schemas...