Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
5
Erster Beitrag:
vor 8 Jahren
Letzter Beitrag:
vor 8 Jahren
Beteiligte Autoren:
Mitch.pcs.crosspost, Arie, Jeff Graham, Malcolm James.pcs.crosspost

Synchronising App version with DB version?

Startbeitrag von Mitch.pcs.crosspost am 28.05.2010 09:11

I know that WinDev includes automatic schema upgrades. But is there any automatic feature for checking that the app version is matched to the correct schema version?

Where is the DB schema version # stored?

For example how do you handle a situation where either the client app version has been reverted but the db schema hasn't, or vice versa? This could lead to data corruption?

I assume that a check must be coded by hand?

Mitch

Message forwarded from pcsoft.us.windev

Antworten:

WinDev does the check automatically for HF and will give an error if the DB does not match the application. The Analysis has version numbers as do the HF data files.

We run WDModFic silently every time our application starts just to make sure they match.

Cheers,

von Jeff Graham - am 28.05.2010 15:40
Thanks Andy.

I'm primarily interested in HFCS. Is there any mechanism to roll back an upgrade?

If the server is set up to automatically upgrade client apps, they will all have been upgraded. If it then becomes necessary to roll back the DB/server, how can the clients be rolled back to match?

If the version is rolled back on the server, would the clients automatically be "upgraded" to the latest version on the server (which would in fact be an earlier version)?

How do Windever's usually deal with this.

Mitch


Andy Stapleton wrote in news message :
>
>
> I have just coded one for MSSQL , checks all stored procedures, create
> tables, modify tables and has option to run a set of scripts defined in a
> table....
>
>
> If MSSQL is what your looking for, holler,I will send it to you.
>
> andy Stapleton
>
>
>
>
>
>
> "Mitch" wrote in message
> news:fd7b8c4175d4cf31b37e11248e4e3398@news.pcsoft...
> >
> > I know that WinDev includes automatic schema upgrades. But is there any
> > automatic feature for checking that the app version is matched to the
> > correct schema version?
> >
> > Where is the DB schema version # stored?
> >
> > For example how do you handle a situation where either the client app
> > version has been reverted but the db schema hasn't, or vice versa? This
> > could lead to data corruption?
> >
> > I assume that a check must be coded by hand?
> >
> > Mitch
> >

Message forwarded from pcsoft.us.windev

von Mitch.pcs.crosspost - am 10.06.2010 13:24
Hi Andy

>> I have just coded one for MSSQL , checks all stored procedures, create
>> tables, modify tables and has option to run a set of scripts defined in a
>> table....

>> If MSSQL is what your looking for, holler,I will send it to you.

Ooh that's something I've got to do in the coming months.
Any chance of throwing a copy thisaways pardner?
[Assuming cowboy refers to a preference for Ye Olde Wilde West, and not your business practises :^) ]


Cheers

Malc


Message forwarded from pcsoft.us.windev

von Malcolm James.pcs.crosspost - am 10.06.2010 14:53
Quote
If the version is rolled back on the server, would the clients automatically be "upgraded" to the latest version on the server (which would in fact be an earlier version)?

According to the help of WD15 it is a new WD15-feature when using a network-setup.

von Arie - am 10.06.2010 15:20
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.