Advantage Database utility .NET/Delphi

CANCELLED
Bids
1
Avg Bid (USD)
$128
Project Budget (USD)
$100 - $150

Project Description:
Hi there
I need a small utility that will reindex all tables in a datadictionary.

If I were to use the Advantage Stored procedure sp_PackTables that would work OK if the tables were created in the same instace of AdvantageDB. However, there is an issue if tables were created in another instance of AdvantageDB. You get a 7074 or 5175 error because there is a collation mismatch.

I wanted to write a quick script to loop through all tables in the DB and reindex them. I also note that with the right skills and knowledge, you can set a property of AdsOpenTable=ADS_REINDEX_ON_COLLATION_MISMATCH
But I am not sure how to do this.

I am not sure if this property is only exposed to Delphi tools of it can be exposed in .NET.

I want a small form, Textbox with either OLE provider string or some kind of database enumeration/selection (path to ADD?)

Reindex button with progress indicator, eg: Tablename being reindexed, and of course a cancel/quit button to close the app.

I have written a small script ato do this and it throws a 7074 error as I beleive it is not possible for me to set the correct values

I have reviewed
http://devzone.advantagedatabase.com/dz/WebHelp/Advantage10.1/index.html?ade_indexcollationmismatch.htm

http://devzone.advantagedatabase.com/dz/webhelp/advantage9.1/mergedProjects/adserror/err5xxx/5175_ae_index_collation_mismatch.htm

http://devzone.advantagedatabase.com/dz/webhelp/advantage9.0/mergedProjects/adserror/err7xxx/7074_the_table_id_stored_in_the_adt_table_does_not_match_the_id_stored_in_the_advantage_data_dictionary_file.htm

The goal of this project is to create an application that will fix errors as a result of copying datafiles from one server to another and using the AdvantageDB. It is not possible to connect the two servers via network and use ADS native tools to do this.

Hope someone out there understands this issue.

Currently using ADS v8.1 & 10.1
REgards ACO

Skills required:
.NET, Delphi, Engineering, Linux, Microsoft, Project Management, Script Install, Shell Script, Software Architecture, Software Testing, UNIX, Visual Basic, Windows Desktop
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.