Devart Forums

Posted: **Thu 03 Mar 2011 07:14**

I have few files and have written hundreds of stored procedures for my different MySQL databases which I have to deploy them again and again on our testing server.

I am using dbForge for MySQL v4.50.335. Can someone tell me how to set Default Database and Folder for Database -> Execute Script menu option.

Thanks

Posted: **Thu 03 Mar 2011 08:58**

You can create a main file that contains SOURCE commands.

Code: Select all

SOURCE 'filename1.sql';
SOURCE 'filename2.sql';
SOURCE 'filename3.sql';
...
SOURCE 'filenameN.sql';

Then open Execute Large Script Wizard, choose appropriate Connection and Database, and execute this main file.

Note: filename1.sql, filename2.sql ... filenameN.sql cannot contain USE statements.

Devart Forums

Setting Default Database and Folder for Execute Script

Setting Default Database and Folder for Execute Script