Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Migration

Status
Not open for further replies.
Apr 23, 2002
52
US
I'm running Informix Dynamic Server 7.31 UC5-1 on SCO 5.04. I have set up a "play" server to practice on. I want to import a database from my "real" server to my "play" server. I don't have a tape drive on the play box. I have read the Informix info on data migration. I understand that I can use OnUnload to put the database I want to move into a file. The Informix info says that I can move the file to the new machine over the network. I need some guidance on how to accomplish that. Would I be using Informix or UNIX to accomplish moving the file from one server to another? Specifics on how to move the file would be most helpful.

Also, when using OnUnload does the database continue to exist on the original server (am I copying or cutting)? Are there any issues that I should be aware of? I am doing this practice run to prepare for a real migration to a new server in the near future.
 
Env. variable are set. Used syntax as suggested. Getting a Cannot open sql error.
 
Started over from scratch. Logged into production server as informix and did dbexport successfully. Used ftp to transfer files in sfatest.exp to directory sfatest.exp on other server. Ran dbimport from parent dir of sfatest.exp.
dbimport sfatest -d mjwdbs
All files set to 770.
Still get error - Cannot open sql script file.
I can open the sql file in dbaccess.
What's going on?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top