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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.