ALTER DATABASE SCHEMA FROM FILE feedback

[#1]

Is there a way to track the execution of an ALTER DATABASE SCHEMA FROM FILE command?

We were wondering if we could follow the progress of a database schema update, to alert the user about how much he should wait until the execution is completed.

Ps: We are targeting the iPhone and Android devices.

[former_SQLA_member1694876 · Accepted solution]

I'm afraid the answer is currently no. And it is true that altering columns or creating indexes can take some time when there are a lot of rows.

I suggest you synchronize any pending changes first, then request users patiently wait for the update to complete (possibly ensuring there is enough power available). Unlike a synchronization/network operation, while the alter-database request is active, you can be sure that work is progressing. Given that, it seems appropriate that the UI thread display some kind of "yes, I'm still alive and working" indication.

[Former Member · Accepted solution]

Could I track the progress somehow using the table observers?

[former_SQLA_member1694876 · Accepted solution]

Sorry, not sure what you mean by table observers...

[Former Member · Accepted solution]

The feature you can use to track modifications in any database object (such tables).
I think the best name is notification (UlConnection.getNotification)

http://dcx.sybase.com/index.html#1201/en/uldotnet/uldotnet-uldnet-ulconnection-cla-getnotification-m...

[former_SQLA_member1694876 · Accepted solution]

Oh yes... we call those events or notifications usually.

But no, currently events will not do what you are asking for here.

[Former Member · Accepted solution]

Ohn.. ok, but thank you anyway.