Re: How to manage the versions of databases ?

I am in a similar problem.
[Quoted] However I have been thinking of the possibility to use the database Properties.
[Quoted] You can create any property you want and store your schema version in there. You would still like to be able to automatically compare 2 databases for differences in tables, their properties, fields etc. so that a nice report is generated with suggested courses of actions.

Check the site http://www.mvps.org/access for some cool ideas.

[Quoted] I know there are some professional tools around, but they will cost you some bucks.
[Quoted] If you get some solution, don't forget to post it here.

--
------------------------------------
 /|  /|  /||\    /|  /|  /| | /
/ |/  |/--||_| /  |/  |/--|/|
------------------------------------

"Nicolas Ecarnot" <nicolas.ecarnot_at_bigfoot.com> escreveu na mensagem
news:9043B7E4Bnicolasecarnot_at_195.25.12.38...


> Hello,


>

> In my company, we sell a huge software that uses huges databases, and we

> modify the scheme of the databases almost every 3 months.

> This is very complex to manage for our customers, and we have to manually

> make big changes in their databases.

>

> We are looking for a way to manage rightly these updates, and we already

> have some ideas, but we can't imagine being the first company to deal with

> that hard problem.

>

> So may you give us some URL pointers to web pages explaining how it's

> usually done, or explain us the theory of updating a database model.

> I suppose that some tools exists, so perhaps you know one of these tools.

>

> Thank you in advance.

>

> --

> Nicolas Ecarnot | E-mail: nicolas.ecarnot_at_bigfoot.com