If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > urgent!!Problem with DataBase Migration

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-05-04, 12:42
moloyus moloyus is offline
Registered User
 
Join Date: Apr 2004
Posts: 9
urgent!!Problem with DataBase Migration

I have to migrate a Informix database from Unix enviornment to SQL SERVER 2000. They are in two saperate box. I have few questions regarding that

1) how do you start the database(informix) in unix enviorment?

2)How do you setup enviorment variables?(or do I need to set up enviornment variable)).

3)How do you export data (I know we can use dbexport in unix prompt)?

4) can I be able to run that .sql file in .exp directory in SQl Server query analyzer?

5)Can I convert those .unl file to .txt file and then do a import in Sql Server 2000.

I will really appreciate if some one give me some clue ASAP. I have to do this with in a week so that the old system can be retired.

Any help would be very appreciated.

Thanks
Moloy Bagchi
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On