ETL and Data Integration tools - Modern ETL software for everyone

Hello

I am looking for a tool which can move data from one database to another with some transformation rules.
I want to evaluate your software.
I downloaded the trial version and installed but want to know how to use it. Is there any user guide that I can use to see how it can be used?

Kiram

Kiran

It all depends which software are you talking about.
We have 7 ETL tools

Please a have a look at our online tutorials + we have PDF documentation which is part of the installation

www.dbsoftlab.com/Documentation/A-Quick-...-and-Enterprise.html

www.dbsoftlab.com/Documentation/A-Quick-...d-ETL-Processor.html

Best Regards
Mike,
DB Software Laboratory

Mike,

I am evaluating the Database Exchange Wizard. I was abe to locate the product documentation for it but I still have some questions. Would you be able to answer them?

Thanks
Kiran

Ask all your questions here that what the support forum for;)

Mike

Hi again,

I am looking for a tool which can migrate certain columns from some tables from one database to another. I tried migrating with one table and it worked perfectly fine yesterday but today when I am trying to migrate data for another table which has a foreign key reference to the table that was used yesterday it does not work.

Here are some questions

• Is there a way to move data from more than one table in the source to one single table in target?
• How do we establish foreign key relationships between tables where a table already exists in target with some data and I am importing data into another table with a foreign key to the first one?
• How does it know which record is linked to which one in the first table?
• How does Mask work while using more tha one excel sheet? What should be specified in Mask?

You help is much appreciated.

Thanks
Kiran

Kiran

>Is there a way to move data from more than one table in the source to one single table in target?

You can use the mask to find tables to move

>How do we establish foreign key relationships between tables where a table already exists in target with some data and I am importing data into another table with a foreign key to the first one? How does it know which record is linked to which one in the first table?

It does not, your target database does.
We try to insert the record =>target database checks foreign keys =>insert fails => you have got a message in the log
you need to copy lookup tables first to avoid this problem

How does Mask work while using more tha one excel sheet? What should be specified in Mask?

>It works same way as mask when you use search mask to find files in windows explorer

table* will find table1,table2,table3
table*1 will find table01,table11,table21

ETC

I think in your case Visual importer professional,
would be a better option for you becaise eventualy you will want to automate entire process and copy all the tables across

Peter