Register  ::  Login
 
Home

Forum

About Us

Contact Us

Services

Jobs
  Forum Update : February 07, 2012
Google AdSense Minimize
  
Welcome to Asbuilt-DBA forum ! Minimize

Here you can find a community of professionals who work with INtools® (SPI) and want to interact and exchange information, including problems encountered, offer solutions, and raise new topics.

This forum is composed of two main sections:
1.      Discussions, which is an open discussion forum where you can talk about any related topic to INtools.
2.      FAQ section that offers a variety of questions and answers regarding INtools.
We hope that you will enjoy participating in this forum. Participation in the forum is free of charge.
If you want to start a new forum, please contact the Webmaster.
Add to Google
INtools is trademark of Intergraph corporation
Forum Groups Minimize
SearchForum Home
  Aggregated  FAQ  Admin Module  TO INITIALIZE W...
 TO INITIALIZE WITH DIFFERENT BACKEND
 
 9/10/2008 5:20:32 AM
User is offlinejay221182
66 posts


TO INITIALIZE WITH DIFFERENT BACKEND
Hi!
Is it possible to Initialize watcom database (backup taken from SQL) in to Oracle database. If yes, then please let me know.

Thanks
Jay Joshi
 9/15/2008 8:47:33 PM
User is offlineadmin
177 posts
5th


Re: TO INITIALIZE WITH DIFFERENT BACKEND

Hi,

Yes you can do it.

You just need to make sure the database in the same version.

 

Ilan

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 9/23/2008 10:48:04 AM
User is offlinejay221182
66 posts


Re: TO INITIALIZE WITH DIFFERENT BACKEND

Hi IIan,

Thnks for reply. But I got problem. I have received watcom database file of Version 07.00.06.02 from my client. They have not specified which Back end they are using. I have tried for MS-SQL 2000 but it gives error while inilizaing, while in Oracle 9i it is through. No error came.

So, Is there any way to find out which backend used for Watcom Backup file?

Regards,

Jay Joshi

 

 

 
 9/23/2008 11:08:41 AM
User is offlineadmin
177 posts
5th


Re: TO INITIALIZE WITH DIFFERENT BACKEND

Hi,

When you change the platform in Intools.ini you need to  change the numbers in the c_ver.pbd from c_ver.mss for mss sql and from c_ver.ora for oracle(open it with notepad) .when you connected to the admin you should connect to the same database version if the target is different version you should create a new one with DBSETUP and after that initialize the watcom database.

I'm not sure what kind of error you get but if this not the case please send me the error.

 

Ilan

 

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 9/24/2008 4:59:07 AM
User is offlinejay221182
66 posts


Re: TO INITIALIZE WITH DIFFERENT BACKEND

Hi IIan,

Thanks for reply. I know this procedure to switch Oracle 7 SQL and vice versa. But my problem is different.

My client has taken backup from Oracle 9i then send Watcom file to us. I don't know which backend they are using so, I have tried in MS SQL 2000. Error coming while initilizing in SQL. So, I have tried with Oracle 9i then no error.

How I can check which backend they are using with Watcom File?

I think now I clear the questation.

Regards,

Jay Joshi
 Page 1 of 2
NextPreviousNo Rating
12Next 
  Aggregated  FAQ  Admin Module  TO INITIALIZE W...
Intools
 Search   Forum Home     
website monitored by
host-tracker.com
website monitoring service

Search Engine Optimization and SEO Tools
My Google Pagerank
Copyright 2005 by AsBuilt - DBA   ::  AsBuilt-DBA  ::  Privacy Statement  ::  Terms Of Use