PDA

View Full Version : How do we distribute databasechanges to our customers



Ole Kirkholt
23-Feb-2006, 03:48 AM
Hello all

We are currently planning to change the database on our products from
Dataflex to MS Sql-server,
and would like some ideas about how to distribute database changes to our
customers in the future.

Currently we are using he vinga-products.

Can we simply distrubute new int-files and an sql-script that does the
actual database-changes when it is run through query-analyzer.

Any ideas and best practices are welcome.


Best regards

Ole Kirkholt,
Microtech Software,
Denmark

Nicholas Herlick
23-Feb-2006, 08:26 PM
Ole,

We face the database update issue using a VDF
"Ole Kirkholt" <ole@kirkholt.com> wrote in message
news:Y%23Wz1XFOGHA.1280@dacmail.dataaccess.com...
> Hello all
>
> We are currently planning to change the database on our products from
> Dataflex to MS Sql-server,
> and would like some ideas about how to distribute database changes to our
> customers in the future.
>
> Currently we are using he vinga-products.
>
> Can we simply distrubute new int-files and an sql-script that does the
> actual database-changes when it is run through query-analyzer.
>
> Any ideas and best practices are welcome.
>
>
> Best regards
>
> Ole Kirkholt,
> Microtech Software,
> Denmark
>

Nicholas Herlick
23-Feb-2006, 08:42 PM
Ole,

We update customer databases using a program that checks file attributes and
does structure changes. The same programs works fine on native VDF files and
BTR files.

Nick

"Ole Kirkholt" <ole@kirkholt.com> wrote in message
news:Y%23Wz1XFOGHA.1280@dacmail.dataaccess.com...
> Hello all
>
> We are currently planning to change the database on our products from
> Dataflex to MS Sql-server,
> and would like some ideas about how to distribute database changes to our
> customers in the future.
>
> Currently we are using he vinga-products.
>
> Can we simply distrubute new int-files and an sql-script that does the
> actual database-changes when it is run through query-analyzer.
>
> Any ideas and best practices are welcome.
>
>
> Best regards
>
> Ole Kirkholt,
> Microtech Software,
> Denmark
>

Allan Greis Eriksen
27-Feb-2006, 04:40 AM
"Ole Kirkholt" <ole@kirkholt.com> wrote in
news:Y#Wz1XFOGHA.1280@dacmail.dataaccess.com:

> Hello all
>
> We are currently planning to change the database on our products from
> Dataflex to MS Sql-server,
> and would like some ideas about how to distribute database changes to
> our customers in the future.
>
> Currently we are using he vinga-products.
>
> Can we simply distrubute new int-files and an sql-script that does the
> actual database-changes when it is run through query-analyzer.
>
> Any ideas and best practices are welcome.
>
>
> Best regards
>
> Ole Kirkholt,
> Microtech Software,
> Denmark
>
>

Hi Ole

You could try out dbUpdateUtil found on www.vdf-guidance.com. I think
this is what you are looking for.


--
Regards,
Allan Kim Eriksen
Programmer/systemconsolent