Đã hoàn thành

329037 MySQL Alter Scripts V2

- use run time parameters: <<db1_connection_string>> <<db1_version>> <<db2_connection_string>> <<db2_version> <<filename>>

filename would be optional and if ommitted, the filename would be defaulted to <<db2_hostname>--to--<db1_hostname>_<<db1_version>>--<<db2_database_name>>-<<timestamp>>.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!

Thanks!

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?

Kĩ năng: Bất kì công việc gì, Perl

Xem nhiều hơn: what pl sql, say anything you want, pl sql statements, for in pl sql, for all in pl sql, 192 168.1.1, in pl sql, alter i, mysql pretty, perl change file, mysql stuff, foreign key, mysql save data, create schema mysql, schema sql, mysql create schema, mysql create table data, mysql quote, mysql indexes keys, mysql output table

Về Bên Thuê:
( 10 nhận xét ) Shallotte, United States

ID dự án: #2074846

Được trao cho:

iainqsl

Will implement everything as discussed by email. Thanks Iain.

$45 USD trong 1 ngày
(0 Đánh Giá)
0.0