MyDac and SDac together

lucasbr · Post by **lucasbr** » Fri 13 Apr 2007 14:12

Hi, I am current mydac customer. I am using D7 Enterprise.

Is it possible to install mydac and sdac? which versions should I have?

I only have mydac without source? Should I upgrade to 5.0 before purchase sdac?

How can I read from mysql server and update sql server?

Is it possible to install trial version to test both working together before purchased?

Antaeus · Post by **Antaeus** » Fri 13 Apr 2007 14:46

lucasbr wrote:Is it possible to install mydac and sdac? which versions should I have?

Yes, it is possible. To use MyDAC and SDAC simultaneously on the same IDE, you should download the latest versions of MyDAC (5.00.0.5) and SDAC (4.00.0.5).

lucasbr wrote:I only have mydac without source? Should I upgrade to 5.0 before purchase sdac?

You should if you want to use MyDAC and SDAC simultaneously on the same IDE.
As an alternative, you can buy SDAC and we will send you a link to download SDAC 3 that is compatible with MyDAC 4. We do not recommend this way because you will not be able to use latest features of both products.

lucasbr wrote:How can I read from mysql server and update sql server?

Please describe this question in more detail.

lucasbr wrote:Is it possible to install trial version to test both working together before purchased?

Yes, it is possible. Just download and install latest version of both products. Do not forget to uninstall the old MyDAC before installing the new one.

lucasbr · Post by **lucasbr** » Fri 13 Apr 2007 14:56

I have this problem.

2 tables in mysql hosted in a web server and the same table, same field
hosted in sql server at a local server.

I need to read from mysql web server and insert the data at local sql server, deleting data from mysql server.

How can I do it using mydac and sdac?

Antaeus · Post by **Antaeus** » Fri 13 Apr 2007 15:59

Try to use the TCRBatchMove component that is included both in MyDAC and SDAC. It is installed on the Data Access tab.
You should open tables on both servers (using TMyQuery and TMSQuery, for example), attach to them TCRBatchMove and run it. After the data is transferred, truncate the source table.

You can also use the TMSLoader component and its LoadFromDataset method to load data into the table on SQL Server from an open TMyQuery.