Kapalı

AutoFix SQL database autimatically (Delphi7)

I need to have my application check the database everytime my application loads. O want it to check the entire schema based on a text document containing all schema information for the database version required by the software version.

i want to automatically generate the schema file.

the application muust then check for errors within the database, for example if an error in the field size occurs i want it to create a script similar to;

;========================================================================

;

; Fri, 16/07/2010 at 23:26:40

;

;========================================================================

;Table CfgMedia

;------------------------------------------------------------------------

;Field [DefName] is wrongly defined

Alter table [CfgMedia] add [AutoFixTemp] VARCHAR(24) NULL

Update [CfgMedia] set [AutoFixTemp] = [DefName]

Alter table [CfgMedia] drop column [DefName]

Alter table [CfgMedia] add [DefName] VARCHAR(24) NULL

Update [CfgMedia] set [DefName] = [AutoFixTemp]

Alter table [CfgMedia] drop column [AutoFixTemp]

;========================================================================

;

; End of script

; Fri, 16/07/2010 at 23:26:42

;

;========================================================================

or if no problems are found then produce a script like

;========================================================================

;

; Fri, 16/07/2010 at 23:26:40

;

;========================================================================

;

; No problems found

;

This is on a very tight budget, but this does need to work;

Basically what i need is;

1) Generate a Schema File for it to compare

2) Check the database against the schema file and if error are found, then automatically create a script to repair the errors.

3) The schema file must have on 1 line the database version so no mistakes can be made where incorrect schemas are processed.

Please help

Thanks

Beceriler: Delphi, SQL

Daha fazlasını görün: sql autofix, autofix sql, set application, schema update, need sql help, sql create database, delphi7 sql, delphi7 sql update, sql software, sql based, null, sql update text, sql update field text, update sql file, compare update, sql create script, database example, sql required, update text sql, sql update text field, incorrect file version, delphi7, schema sql, schemas, text sql

İşveren Hakkında:
( 0 değerlendirme ) Margate, United Kingdom

Proje NO: #740724

4 freelancer bu iş için ortalamada 87$ teklif veriyor

qulibin

have 10 years experience, since Delphi5. 8+ years of Delphi7 experience. I can give you appropriate sample work.

1 gün içinde 200$ USD
(2 Değerlendirme)
4.0
bestjobs4u

Hi, Please check pmb. Thanks & regards reddy

in 2 gün içinde49$ USD
(0 Değerlendirme)
0.0
jackwsun

We are interesting.

in 5 gün içinde50$ USD
(0 Değerlendirme)
0.0
ChicagoBoy

I am highly interested in this project.

in 10 gün içinde50$ USD
(0 Değerlendirme)
0.0
vlopes777

Hi there I'm a programmer for more than 10 years using vb6, sql, pl-sql, crystal reports, and also more than 2 years using vb.net I can do this Count me in

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0