By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,275 Members | 1,990 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,275 IT Pros & Developers. It's quick & easy.

Best practice on local database Schema update

P: n/a
RS
Hello All,

Does anyone know what the best practice is for updating database
schema? We are designing a smart client application where the .Net
application is used online and offline. If the computer is connected
the application communicates directly with the main database and if it
is disconnected it communicates with the local database. When the
machine is connected again, data gets syncronized. Now, if we want to
update/modify the database schema in the local data base of each
machine, should that be done during the database syncronization or can
we use the Updater Application Block or clickonce to do that job? Most
likely we will be using SQL Server Express as our local database and
SQL server 2000 or 2005 as the main database.

Cheers,

Tom

Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi,

http://msdn.microsoft.com/library/de...dunplugged.asp

Ken
---------------
"RS" <lo**********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Hello All,

Does anyone know what the best practice is for updating database
schema? We are designing a smart client application where the .Net
application is used online and offline. If the computer is connected
the application communicates directly with the main database and if it
is disconnected it communicates with the local database. When the
machine is connected again, data gets syncronized. Now, if we want to
update/modify the database schema in the local data base of each
machine, should that be done during the database syncronization or can
we use the Updater Application Block or clickonce to do that job? Most
likely we will be using SQL Server Express as our local database and
SQL server 2000 or 2005 as the main database.

Cheers,

Tom

Nov 21 '05 #2

P: n/a
RS
Thanks Ken

That website talks about database syncronization but it did not mention
anything about updating the database schema. Any info about that?

Thanks

Nov 21 '05 #3

P: n/a
RS,

What in my opinion is not clear in your message is what you mean with
udating the database Schema.

Your text talks about updating the databases on local and central side.

It is very strange to update the database Schema, because that would mean
that every user has another Schema and data will be lost.

Just my thought,

Cor
Nov 21 '05 #4

P: n/a
Tom,

I am not sure whether this will be best practice or note, but updating
database schema can be done by implementing replication, and
configuring client databases (Express 2005) as subscribers to central
database (SQL Server 2000/2005). Please go thru the SQL Server Books
online for details on replication.

-
Hari Sharma

Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.