How to deploy database application built on VB 6 and Oracle?

190 pts.
Tags:
Application deployment
Database programming
Oracle 8i
VB
I am developing an application with VB 6 as front end and Oracle 8i as back end. I need to run my application in other systems also, so I need to export the table structures of my application to other systems. How can I do this? Thank you.
ASKED: July 16, 2008  3:51 PM
UPDATED: July 16, 2008  5:49 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

There are a number of ways to “export” the table definitions from Oracle. It depends on your desired use. Oracle has an export utility which you can use to export. On a UNIX system, the command is “exp”. There are various options to export just definitions (schema) or both schema and data. The generated file is only usable or “importable” into other Oracle databases, so it has limited value. If you choose this route, be sure to remember that the file is binary and if you transfer or “ftp” the file be sure to select binary mode.

You also could use a number of other facilities to generate files with the table descriptions or to generate table create statements which could be used to create those structures in another SQL based database system.

I suggest working with your Oracle DBA to identify the method and utilities which will best meet your needs.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following