Skip to Content
author's profile photo Former Member
Former Member

Data Source Migration Wizard

Post Author: hd1

CA Forum: Administration

We are planning on converting 2 databases in our firm and our current Crystal Reports will need to have their data sources updated. Is there an easy way to do this? Currently one database is our informix database and we are converting that one into a SQL 2005 and the other is a Carpe Diem database and that is being converted to a SQL 2000. I know I should have to go into each report and manually update these data connections, we currently have about 200 reports that are running, so that would take a long time. I ran across this tool on our server called Data Source Migration Wizard. Has anyone used this tool for this scenario or an I using the wrong source?

Add a comment
10|10000 characters needed characters exceeded

Related questions

10 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 09:51 PM

    Post Author: Ranjit

    CA Forum: Administration

    Just a vague idea

    Can you have same dataabse link for the new database as old one had?

    But I'm not much aware of Informix database so dont know if SQL providers will will work for Informix database.... so suggestion may be useless.

    Regards

    Ranjit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 10:10 PM

    Post Author: hd1

    CA Forum: Administration

    I don't know. That could work. We did decide to keep the database names the same, but I don't know if that will make a difference or not. I don't even know how to find out if that would work. Database structures are still new to me.

    Thanks,

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 11:10 PM

    Post Author: Ranjit

    CA Forum: Administration

    Hi Brian

    I work on Oracle, but the case was as below.

    We had a old server(actually a desktop) hosting database and data Historian, Data historian was creating problems because of old configuration, so we had to move both applications to different server.

    So we created new database on the new server with same structure and data, Now on the client (where reports are hosted) in oracle home directory there is a tnsnames.ora file where we specify host details; here I kept same TNS Name as old database and specified IP address port etc of new server. So we need not have same database names but tns names can handle this.

    This made reports working.

    Next thing was; An oracle application was using old database link, which used to generate different reports. We had to drop link from old database and create a new public link with same name for the new database. This served all our DB migration problems.

    Now For your case:

    If database structure is different - I mean tablename, schema name are differnet you can not certainly use the same reports - complete report need to be regenerated.

    If database structures are different, How you carry forward your historic data will be interesting. You certainly can not just dump the data in this case.

    Please keep us informed how you get along this.

    Best luck!

    Ranjit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 12:02 AM

    Post Author: hd1

    CA Forum: Administration

    I was afraid of that. I did happen to try a test run on this. When I updated the datasource of the object, I lost a lot of information in my report such as my groups and even my cross-tab. Why is this? Is it because the report loses it's connection for a moment and then is re-established?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 07:27 PM

    Post Author: Ranjit

    CA Forum: Administration

    It should not happen if your databases have same structure and you are changing it from database => set datasource location, and you are not using command objects in your report.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 07:32 PM

    Post Author: hd1

    CA Forum: Administration

    The structures appear to be the same, but what do you mean by 'command objects'?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 09:21 PM

    Post Author: Ranjit

    CA Forum: Administration

    Go to database=>Database Expert=> create a connection, now instead of adding a table, use option "Add command". Here you can write your own query. Since this query looses reference to its tables - it does not allow to change database connection.

    In that case you will have to recreate this command.

    Ranjit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 09:32 PM

    Post Author: hd1

    CA Forum: Administration

    Oh, I see what you mean. I only have one report that is using a SQL statement I got my terminology mixed up. Fortunately the report that has the SQL statment isn't being moved so I should be ok. I did learn that the reason I was losing my references in my database because I was just updating the one instance of my connection, the server. I found out through the knowledge base that I should update each table invidually. This way it keeps my reference. I was able to try it on one report that I created but the other reports will not run because not all the data has been migrated. I still don't think there is a way to keep certain things from being deleted from the report though, the cross-tab still got deleted so I did have to recreate that but it wasn't a big deal. I was hoping there would be a way to do all these reports at once but from the looks of it I think I will have to do them one at a time.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2007 at 07:42 PM

    Post Author: TAZ

    CA Forum: Administration

    There are a few things you can do.

    1) Using our SDK you could create code that will modify the DB info for all or groups of reports (don't ask me how I don't write code).

    2) For scheduled reports you can use the schedule manager in the adminlaunchpad to bulk reschedule and change the datasources at the same time

    3) The publishing wizard can set db credentials for bulk reports but this would mean you have to republish everything and delete any old instances remaining (much messier than using SDK code)

    4) Manually changing the DB in the CMC

    The datasource migration wizard is meant to migrate older reports based on "weird datasources" to XI not change DB credentials

    Regards,

    Tim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2007 at 07:50 PM

    Post Author: hd1

    CA Forum: Administration

    Hey There!

    Thanks for the info, I already have these migrated over though. I ended up going into each report and manually updating the datasource. It was very time consuming but I got it done, I actually just finished last Friday. It was strange because some reports I had to remap certain fields. So far they seem to be running smooth and I did hit a few bumps here and there. One problem was that once the information was migrated to the SQL database, it time stamped everything. So I had to go back and reformat the date. Other than that everything is working smooth.

    Thanks for your help!

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.