ETL and Data Integration tools - Modern ETL software for everyone

Hi There
Thanks in advance for the help. I create two connections ODBC to access and I want to copy some tables or could be all from database in conexion1 to the database in conexion2.

Is possible to use a sentence SQL for that? or script and how to use it..

thanks a lot for the help

Cheers
Hugo

Database browser was not desighed to do that

Have a look at Visual Importer Professioal
It has got a wizard which will help you to copy data between differrent databases.

(You would need to create target tables youurself)

Mike

www.dbsoftlab.com/online-tutorials/visua...server-database.html

Have a look at this tutorial as well

Peter

Thanks very much for the help, but I am running the application in a virtual desktop (Citrix Plattaform)so need to be a portable software (No right to install a software). are there any version of the software in a portable version. I need to copy a access database but some of the tables are linked to other tables so is not just copy the database that is in access has to be copying with the execution of a query as Databrowser does or maybe be visual importer.

Thanks a lot for your help and hope you could tell me the right software for me.

Cheers
Hugo

does the program came in a portable version?? need to run it in a virtual desktop??? Thanks very much

Install Visual Importer on your local PC, than copy entire folder across, run it and point to default repository.

I am afraid you will not be able to fing portable database management software it does not exits.

There no such thing like portable DTS, SSIS, Oracle or MS Sql server

Peter