Best practices for updating data base
Follow along as Chris shares his experiences and provides tips and techniques for getting the most out of DB2 including how to exploit new features and releases as they come on-line.
Chris is a DB2 for Linux, UNIX and Windows lifer having worked at IBM on DB2 since its inception.
This will optimize connectivity by reducing the latency between the application and database servers.
Traditionally, your web servers and database servers would be in the same facility, but SQL Azure is hosted in several data centers around the world.
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.
Databases whose architecture or data is not required to be updated should be considered to be set as READ ONLY databases.The following script provides an outline to start with.Hello All, Does anyone know what the best practice is for updating database schema?We are designing a smart client application where the . 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.