1

Topic: Transfer of projects Ms SQL in Mysql

Kind time of days!
Prompt can at whom there is an experience of transfer of projects Ms SQL in Mysql.
Pattern such on Delphi XE3 programs from DB Ms SQL 2008 are written was used ADOConnnection. Now set the task to transfer all in MySQL. As it is possible to adjust connection so it would be possible to transfer programs without setting of additional components at clients. In advance thanks.

2

Re: Transfer of projects Ms SQL in Mysql

To use instead of ADO Firedac?

3

Re: Transfer of projects Ms SQL in Mysql

It separately to be put? That that did not find in Delfi

4

Re: Transfer of projects Ms SQL in Mysql

Erkanat.iman;
It like the paid.

5

Re: Transfer of projects Ms SQL in Mysql

Erkanat.iman wrote:

Kind time of days!
Prompt can at whom there is an experience of transfer of projects Ms SQL in Mysql.
Pattern such on Delphi XE3 programs from DB Ms SQL 2008 are written was used ADOConnnection. Now set the task to transfer all in MySQL. As it is possible to adjust connection so it would be possible to transfer programs without setting of additional components at clients. In advance thanks.

Actually it will be the full rewriting of the project. Rather painful, if code more, than 5-7..
Recommend under any pretext  the requirement to lower on brakes. smile

6

Re: Transfer of projects Ms SQL in Mysql

Erkanat.iman> Prompt can at whom there is an experience of transfer of projects Ms SQL in Mysql.
I transferred on FB. On MySQL somehow would not occur.
> Now set the task to transfer all in MySQL.
And than this requirement is caused/is justified?
, sanctions,  the principal or what?

7

Re: Transfer of projects Ms SQL in Mysql

In general the task delivered to the program to make a web the interface, those who solve the task on a web. Solved in mysql translates, the server under Linux and mysql that it is free, in general to me of suffering

8

Re: Transfer of projects Ms SQL in Mysql

So MSSQL too under Linux already is

9

Re: Transfer of projects Ms SQL in Mysql

And generally, then to your software do  from rest services, and let  them pull under the web interface...

10

Re: Transfer of projects Ms SQL in Mysql

X-Cite wrote:

to your software do  from rest services, and let  them pull under the web interface

at me the colleague it is direct from  json such valit:-Q

11

Re: Transfer of projects Ms SQL in Mysql

Erkanat.iman wrote:

in general the task delivered to the program to make a web the interface, those who solve the task on a web.
Solved in mysql translates, the server under Linux and mysql that it is free, in general to me of suffering

For this purpose it is not necessary to translate anywhere anything. Leave a master server on MS SQL,
Adjust replication on slave MySQL and let "those who solves the task on a web" have a good time
With it as are able.

12

Re: Transfer of projects Ms SQL in Mysql

wrote:

5/23/2018 11:54, X-Cite writes:
> To your software do   from rest services , and let  them pull under the web interface...
, UEB-dezignery requested MySKL and words such do not know that...

Most likely you are right

13

Re: Transfer of projects Ms SQL in Mysql

Erkanat.iman wrote:

in general the task delivered to the program to make a web the interface, those who solve the task on a web. Solved in mysql translates, the server under Linux and mysql that it is free, in general to me of suffering

Most likely you are a liar! Also it is your own ideas

14

Re: Transfer of projects Ms SQL in Mysql

MaratIsk wrote:

it is passed...
Most likely you are a liar! Also it is your own ideas

Not my idea, I would make easier,  the apache and  on 2008 and would not suffer with passage.
Is better would offer what  a variant, stopped on FireDac.
All thanks for sentences well and for criticism

15

Re: Transfer of projects Ms SQL in Mysql

Erkanat.iman wrote:

I would make easier,  the apache and  on 2008 and would not suffer with passage.

That is the apache and pyh-pyh you can, and  for replication in  - outside of yours
Possibilities? The Nu-nu...

16

Re: Transfer of projects Ms SQL in Mysql

Dimitry Sibiryakov wrote:

it is passed...
That is the apache and pyh-pyh you can, and  for replication in  - outside of yours
Possibilities? The Nu-nu...

Did not do such, at all I do not represent as it to do, can prompt?

17

Re: Transfer of projects Ms SQL in Mysql

Erkanat.iman wrote:

at all I do not represent as it to do, can prompt?

Is better - to roll out to the heads of an abacus for Golden the Gate. At them can sharply exchange
Priorities. And differently - Google to you in hands:
https://blogs.msdn.microsoft.com/mattm/ … from-ssis/