- use run time parameters: &lt;&lt;db1_connection_string&gt;&gt; &lt;&lt;db1_version&gt;&gt; &lt;&lt;db2_connection_string&gt;&gt; &lt;&lt;db2_version&gt; &lt;&lt;filename&gt;&gt;
filename would be optional and if ommitted, the filename would be defaulted to &lt;&lt;db2_hostname&gt;--to--&lt;db1_hostname&gt;_&lt;&lt;db1_version&gt;&gt;--&lt;&lt;db2_database_name&gt;&gt;-&lt;&lt;timestamp&gt;&gt;.sql
eg. [url removed, login to view] [url removed, login to view]:schema:user:pass 1 [url removed, login to view]:schema:user:pass 2 [url removed, login to view]
- output create table statements for missing tables
- save all output to a text file specified
Have i missed anything?
No that's good.
Where you want the file saved to or should i have this as a script setting?
Yea make that a script setting
Have you thought about adding support for constraints?
Meaning stuff like if I change a field from varchar(50) to varchar(100) , indexes, primary keys etc? I was going to wait till another version for this or until around the time I actually needed it. Go ahead and give me a quote on this part separately from the other quote. I may go with it now and I may have to wait.
I installed PERL last night on windows and the package manager came up when I hit PPM, I typed in MySQL the package came up, actually quite a few, I picked the DBD:MySQL one and it installed, I have to agree that was pretty awesome!
Shall we say $25 for what we have agreed below or $45 including the ability to pick up field data type changes, indexes, primary keys and foreign key constraints?