Question:
Hi All,
Thank you. We will do that. Also, is there a difference between Client Copy and System Copy. Also, do we need to make sure that the we bring the database size same between the two systems. Suppose we have 20 GB filled on BW PROD( there is a lot of data available, BW PROD occupies only 5 GB withour data in cubes and we have 6GB available on QA ), now when we decided that we want to do a system copy from BW PROD to BW QA, then do we need to definitely make suer that the sizes are same?
Thanks
- Jim
Answer:
this sounds like something for the BC forum...
Answer:
Excuse me All,
Let me rephrase the questions:
1. Is client and system copy are the same?
2. When we do the system copy do we need the traget system to
to be of the same DB size as the source system? or is there a way
to copy only the structures.
Thanks
- Jim
Answer:
1. No it is not.
2. Yes and No, it depends on your DBMS and how it handles table/db growth.
You have several options for copying between systems. You can do a full DB (system) copy. You will need the same amount of space in your target system as in you have in the source system.
You can also look at doing a cross-system client copy w/ and w/o data. This is not a straight forward process, but it is doable. Checking out the Basis forum you should be able to find someone there w/ more knowledge of this process and other options you might have. (I only know there are several options in this arena, from talking w/ Basis ppl, but I don't know any more on the specifics)
- Stephen
Answer:
Thanks Stephen,
You mean to say that the System Copy is easier than the client copy. We have only one client as BW supports only one.
Please advise ..
Thanks
- Jim
Answer:
No, one is not easier then the other, they are just different - they serve different purposes. Client copys are intended for copying between clients in a system, though you can use it across systems.
It just depends on what your goal is as to whether you would use one process or the other.
I cannot provide more of a recomendation, a Basis person can really give you the details on pro's and con's of different methods. I myself have only been peripherally involved in some of our client and system copies here.
- Stephen