Moving to new Database

[raja2008]

Hello Everyone!

Please give information in detail.Because i have no idea about how this can be done.

Problem:We are moving one of the databases from older version of sql server to SQL Server2005.There are lots of reports earlier on this server.
Some are created by the person worked earlier.

My question is how i will know all the reports that are pulling data from this database.
What are the actions i should be taking in the move.
What is the bestway to get rid of problems that i will be facing in the future because of this.

What are the steps i should be taking .
Iam just report developer,what i should be doing from myside.

Please mention what kind of problems you faced and how you resolved,iam new to this.

Thank you for reading .

 

[raja2008]

iam sorry i forgot to mention

iam using crustal XI R2 with Business Objects XI R2 Enterprise

 

[hilfy]

All of the reports that point to the old server need to be changed to point to the new one. There are several ways this can be done.

1. Open each report in Crystal, point it to the new database, save it. If you do this by opening the reports in Crystal by connecting to your BO Enterprise system, you don't have to republish them.

2. Write a program (or have someone write it...) using the SDK that will access the reports in BO Enterprise and set them to a custom database instead of the one they're saved with.

Option 2 is probably a much faster way to go if you can write code or you have a programmer available. The program can be written to open every Crystal report in the system, look for the connection to the old database, and only update those reports that have that connection. I've done some similar things in C#.NET and may be able to provide you with some sample code.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[raja2008]

hello

thank you very much for your response.

I like the last option -because there are reports done by others that worked earlier on this database,I know nothihg about c#.net ,can you point me to it,explain in detail what i exactly have to do.

About the first option what do youmean by "If you do this by opening the reports in Crystal by connecting to your BO Enterprise system, you don't have to republish them"
please explain in detail.

Thank you

 

[hilfy]

For Option 1 - Open Crystal. Select File|Open from the menu. In the screen that comes up, at the bottom of the panel on the left is "Enterprise". Select this and you will be asked to log in to your BO XI system. From there you navigate the folders to get to your reports that have already been published. When you save a report opened this way, it updates the report file in BO XI and you don't have to re-publish it.

In order to write the program in C#.NET, you have to have Visual Studio installed and you have to be familiar with how to write a program, which is different from developing reports.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[raja2008]

Is there anyway we can find out the reports that are pointing to this database.

i dont have visual studio .
If you can give some more information that would be great.

may be i can get someone to do it for me from my organisation

 

[hilfy]

Yes, you can find out which reports are pointing to the db, but again, it takes writing some code using the SDK. I can see where this would be a good utility to have on my end, along with sample code to post to my website, but I'm not sure when I would have time to put something like this together as I'm in the middle of preparing for our upgrade to XI 3.0.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[Turkbear]

Hi,
This page ( the admin launch page)

http://YOURBOESERVER/businessobjects/enterprise115/WebTools/adminlaunch/default.aspx

Has a listing for 'Report Datasources' under the Admin tools section..This, combined with the instance Manager ( in the same list) will allow you to both identify the datasources for each report and , in the instance manager, change all in a folder at one time to a new datasource.






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi,
Just to be clear, the above method only works on published reports..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[raja2008]

thank you for all your suggetions.
I will look into them.
Still more suggetions welcome .

 

[raja2008]

I have a question:

If i use the same DSN name and change the server name in the DSN Configuaration ,will that work.

we are moving from SQL server 2000 to 2005.

 

[hilfy]

Probably. I haven't tested anything like this, so I can't tell you for certain that it will. I would try this in your test environment to make sure that it works.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.