TestComplete works with any databases in the same manner. All you need to do is to use different connection strings. If you need to compare different tables, I recommend that you use the Database Table Checkpoints feature. Please see the "Database Table Checkpoints" help topic for more information.
The "database table checkpoint" uses connection string with the "SQLDataBase". It takes the data from the SQLDataBase and puts it in "database table checkpoint". Then compares the "database table checkpoint" with the data in the "SQLDataBase". It is not quite what I expected and it is not what I wanted to happen.
However, your suggestion have sparked another idea/solution to compare 2 databases. I am trying different connection strings to achieve the following, but failed:
- Connect to "Oracle DB" and take data from the database and put into "database table checkpoint(1)".
- Connect to "SQLDB" and take data from the database and put into "database table checkpoint(2)".
- Compare data in "database table checkpoint(1)" with data in "database table checkpoint(2)".
I am having difficulty to compare the data in the 2 databases. what is the string to compare those 2 tables? (I am codeing in VBscript)
If you need to compare two different databases, you can act as follows:
- create a DBTable checkpoint for database A;
- in your script, change the ConnectionString property of the checkpoint so that it points to database B;
- run the checkpoint from your script.
As a result, the checkpoint will validate data stored from database A with the current data in database B.