Connect to 2 databases
- Thread starter nate100
- Start date
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
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
Curmudgeon
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
ProgressTalk.com Sponsor
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.
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?
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?
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.
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.