Connect to 2 databases

[nate100]

I need to do a CIM file and be connected to 2 databases at one time.
Does anybody know how to connect to 2 databases at 1 time?

Thanks

 

[TomBascom]

You just list them on the command line:

mpro -db dbname1 -db dbname2

or use the CONNECT 4gl statement.

 

[nate100]

Thanks for your response.
I need to connect it so that I can move data between 2 databases.

I am not sure if I should use the following as I need to have other people access the databases as well.
CONNECT mydb1 -1 -db mydb2 -1 NO-ERROR.

What we have above is only for single user mode. I need to have it so that others can access the database as well.

Thanks

 

[TomBascom]

Thanks for your response.
I need to connect it so that I can move data between 2 databases.

I am not sure if I should use the following as I need to have other people access the databases as well.

CONNECT mydb1 -1 -db mydb2 -1 NO-ERROR.

What we have above is only for single user mode. I need to have it so that others can access the database as well.

If you don't want a single user connection then:

1) Start a server for the db (use proserve).
2) Remove "-1" from your command.

 

[tamhas]

I need to connect it so that I can move data between 2 databases.

Thanks

Do the databases have the same schema? Overlapping schema? Or mutually exclusive schema?

If they are not mutually exclusive, then you will need to use aliases to identify which database you are talking about at any given time. I would consider doing this in code rather than at the command line since you will then have complete control. Just remember that you have to move down into a subprocedure to use a database after connecting to it.

 

[sphipp]

Do you really need to be connected to 2 databases at once for this?

If you are doing a CIM Load it sounds as though this is MFG/PRO.

Do you want to copy data from one database to another?

If so, it might be better to generate the CIM file from database 1, then load the CIM file into database 2.

Don't forget that an MFG/PRO CIM Load is essentially a batch process and you don't really want to be doing it with 2 databases connected with the same schema.

What are you trying to do?

 

[nate100]

Hello,
I am trying to move records from 7.1.1 (QAD) from one server to another. I am doing this by CIM loading.

Thanks

 

[sphipp]

You shouldn't need two databases connected.

With CIM Loads, it is better to do it in different stages.

First, generate your CIM data file. (Database 1)

Then double-check the CIM data file.

Then run the CIM Program to load that into another database. (Database 2)

Then double-check the loaded data. (Database 2)

The whole point of a CIM Load is that you are automating the loading of data by replicating keystrokes in a standard QAD Data Input Program. This means that you can take advantage of any extra processing done by QAD rather than simply creating records.

If you had 2 databases connected, you would have trouble with running any QAD Programs as all the table references will be ambiguous.

There is a recent example of a CIM Load using 7.1.1 on the QAD Forum http://www.progresstalk.com/showthread.php?t=109596.

Hope that helps a bit.