Hi,
I'm trying to do a schema comparison and then generate a final sql file, everything from a simple batch file. I'm really not understanding how to do this.
This is what I'm trying but is NOT working, thanks in advance for your help:
"C:\Program Files (x86)\Devart\dbForge Studio for MySQL\dbforgemysql.exe" /schemacompare /source connection:"User Id=root;Password=mypwd;Host=mysql.myhost.it;Port=6100;Database=mydb;Character Set=utf8" /target connection:"User Id=root;Password=mypwd;Host=backup.myhost.it;Port=6200;Database=information_schema;Character Set=utf8" /IgnoreForeignKeys:No /IgnoreDefiner:Yes /IgnoreAutoIncrement:Yes /IgnoreAvgRowLength:Yes /IgnoreColumnDefaultValues:No /IgnoreTableEngine:No /IgnoreDefiner:Yes /UseCommitMode:No
Doing this simply loads dbforge without doing anything...... help! Thanks a lot :)
PS: I'm running dbforge mysql 4.50.308 Professional Trial Edition (28 days left) under Windows 7 64Bit Ultimate.
Command Line Help
You have done everything right, except specifying dbforgemysql.exe instead of dbforgemysql.com, i.e., you should type in the command prompt the following:
"C:\Program Files (x86)\Devart\dbForge Studio for MySQL\dbforgemysql.com" /schemacompare /source connection:"User Id=root;Password=mypwd;Host=mysql.myhost.it;Port=6100;Database=mydb;Character Set=utf8" /target connection:"User Id=root;Password=mypwd;Host=backup.myhost.it;Port=6200;Database=information_schema;Character Set=utf8" /IgnoreForeignKeys:No /IgnoreDefiner:Yes /IgnoreAutoIncrement:Yes /IgnoreAvgRowLength:Yes /IgnoreColumnDefaultValues:No /IgnoreTableEngine:No /IgnoreDefiner:Yes /UseCommitMode:No
Command line supports three ways of working:
1) Type all the arguments directly in the Command Prompt, for example:
/schemacompare /source server=server_name database=database_name user=user_name password="password"
/target server=server_name database=database_name user=user_name password="password"
2) Specify a path to a previously saved comparison document to use the connection settings along with the comparison settings specified in the document, for example: /schemacompare /project D:\file_name.scomp
3) Type the path to a previously generated file with required command line arguments, for example:
/schemacompare /argfile D:\file_name.txt
You've chosen one of the most difficult ways of comparison. The easiest way is to perform comparison in the GUI, save the scomp comparison project, and then use it in the command line with the minimal number of options.
Find more information in Command line usage topic.
"C:\Program Files (x86)\Devart\dbForge Studio for MySQL\dbforgemysql.com" /schemacompare /source connection:"User Id=root;Password=mypwd;Host=mysql.myhost.it;Port=6100;Database=mydb;Character Set=utf8" /target connection:"User Id=root;Password=mypwd;Host=backup.myhost.it;Port=6200;Database=information_schema;Character Set=utf8" /IgnoreForeignKeys:No /IgnoreDefiner:Yes /IgnoreAutoIncrement:Yes /IgnoreAvgRowLength:Yes /IgnoreColumnDefaultValues:No /IgnoreTableEngine:No /IgnoreDefiner:Yes /UseCommitMode:No
Command line supports three ways of working:
1) Type all the arguments directly in the Command Prompt, for example:
/schemacompare /source server=server_name database=database_name user=user_name password="password"
/target server=server_name database=database_name user=user_name password="password"
2) Specify a path to a previously saved comparison document to use the connection settings along with the comparison settings specified in the document, for example: /schemacompare /project D:\file_name.scomp
3) Type the path to a previously generated file with required command line arguments, for example:
/schemacompare /argfile D:\file_name.txt
You've chosen one of the most difficult ways of comparison. The easiest way is to perform comparison in the GUI, save the scomp comparison project, and then use it in the command line with the minimal number of options.
Find more information in Command line usage topic.
