Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Moving reports to a different database

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Moving reports to a different database
 Login/Join
 
<niuniu>
posted
Good morning everyone,

I have some reports created in DB2, now I am going to use these reports in SQL Server, what are the better ways to make the reports running in SQL server database? Do I need to reset path, create sql server adapter , create synonymy. I don't think I have to recreate the reports.

Thanks a lot.

Niuniu
 
Report This Post
<JG>
posted
First make sure that you have a license for the MSSQL adapter.

If that's OK

Backup your DB2 metadata
configure the MSSQL adapter
Regenerate the required metedata

Your reports should run without any changes UNLESS your table definitions are different or you use DB2 Specific SQL passthrough.
 
Report This Post
<niuniu>
posted
Thank you very much for the quick response.

Why do I need to back up DB2 metadata? I can't just configure MSSQL adapter and create new set of required metadata into a different folder? if I have to back DB2 how I can do that?

Thanks a lot.
Niuniu
 
Report This Post
<JG>
posted
The reason for backing up the DB2 metadata is so that is you want to switch back to DB2 you can do it very easily.

It's perfectly OK to create the MSSQL metadata in a different APPS directory but you will have to change your procedures or profile so that it looks at the alternate APP directory.

To back it up if you have direct access to the server directories you just need to copy them.
If your doing it through devstudio you can you can simply drag and drop them in the data servers tree. It's also possible via the Web Console.
 
Report This Post
<niuniu>
posted
Thank you, your posting is very helpful.

After I back up DB2 metadata,do I have to remove the old ones so I can create MSSQL Metadata into the same place, because they have to be exactly the same names for both databases.
 
Report This Post
<JG>
posted
No and yes, It depends on your version of WebFocus.

There is a replace or overwrite option but it did not work 100% in all versions.

The best idea is to use the Web console and create them there.
Delete the old and create them again.
You need admin privellege on WebFocus for that
 
Report This Post
<niuniu>
posted
Very good, Thank you ! Smiler
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Moving reports to a different database

Copyright © 1996-2020 Information Builders