Hey there everyone,

For my first ever post on vbforums I thought I would write about something that has been a right pain in the CPU.

I have been looking for several weeks now for a low cost (or preferably free) module or other kind of add in that will allow me to update or create a database system. which will be used for one of my VB6 Applications, so i can easily update the structure of the database when I make a new version of my application. Thus far I have had no success (Except for the ones that cost money of course).

However I have decided that the best way to accoplish this would be just to create an empty set of tables in a database to form a model database. This way I can just compare the model to the live database and alter or add as appropriate.

I have written a module that will accomplish the update and am now getting ready to compile it in some form.

I am however wondering if this might be a useful tool for anyone here?

I also want to ask what and how is the best way is to compile my script to a dll or similar form?

At present My script supports MySQL only, and I have created the script so if like me your database needs more than 1 set of the same tables you can add a suffix to the table name. If there is a need for a script like this then give me a shout as I am also looking into making the script compatible with a whole host of Databases, Including: -

MSSQL, Oracle, PostgreSQL, Access, MySQL, DB2

Also if things go well maybe even to others not yet stumbled upon.

Also if there are any features that may be useful to the script I would be willing to add any possable requests.

------ Life is a waste of time ------
------ Time is a waste of life ------
------ Get wasted all the time ------
- and you'll have the time of your life -

Izzy Out.