Execute DBForge Schema compare script

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ads42
Posts: 36
Joined: Tue 08 Jan 2013 14:13

Execute DBForge Schema compare script

Post by ads42 » Tue 08 Jan 2013 14:23

Hi,
in order to apply Database changes from a DBForge Schema compare script, what components do you suggest ? TMyCommand ? in this case I load the sql file in the sql property ?

Regards

Armindo

AndreyZ

Re: Execute DBForge Schema compare script

Post by AndreyZ » Wed 09 Jan 2013 09:24

Hello,

To execute a script, you should use the TMyScript component. For example, if you have the script in a file, you can use the following code:

Code: Select all

MyScript.SQL.LoadFromFile('filename');
MyScript.Execute;

ads42
Posts: 36
Joined: Tue 08 Jan 2013 14:13

Re: Execute DBForge Schema compare script

Post by ads42 » Wed 09 Jan 2013 10:36

Thanks Andrey.

AndreyZ

Re: Execute DBForge Schema compare script

Post by AndreyZ » Wed 09 Jan 2013 11:40

I am glad I could help. If any other questions come up, please contact us.

ads42
Posts: 36
Joined: Tue 08 Jan 2013 14:13

Re: Execute DBForge Schema compare script

Post by ads42 » Wed 09 Jan 2013 12:45

yep, I have another pending question about backup/restore in the forum...


Post Reply