I want an application writen in Delphi to do the following. I will load 2 different SQL scripts (database and tables creation). The script will check for differences between 2 and 1 and suggest what changes must be made to database 1 to be exactly as database 2. When I say changes I mean what table create/alter, field create/alter, indexes, keys etc must be made. The application must only suggest database structure not records changes. It should work with MySQL 5.5+ as well as SQLite scripts. No other database is required.
Hi,
I have pretty good over 10 years experience in Working in Delphi and using mySQL. I know exactly what you want. I can provide you in output the exact mysql script which can be just executed to make both mySQL based database similar. The alter includes Table, Fields, Indexes, Primary Key, Constraints / Defaults (if any).
Please let me know which Delphi Version you want this, I can made it in Delphi 7 or Delhi 2010.
Thanks & Regards
Sandeep Verma
€100 EUR in 4 days
5.0 (17 reviews)
4.6
4.6
5 freelancers are bidding on average €154 EUR for this job
Hi, my question is that is it good for you if the application is in java or you accept delphi only? I have a very good idea, how to do this. I like the project description.
Hi,
I have experience in programming since 2002.
My skills:
C# (VS 2008-2013), Win Forms, Linq, EF, Web Services, WCF.
Delphi 5-XE7, DataSnap, BDE, ADO, IBX, OLE, ActiveX
Databases: MSSQL, Interbase/FB/Yaffil, MySQL, MS Access
Thanks,
Vasiliy