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.

Search for best practices for updating data base:

best practices for updating data base-47

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “best practices for updating data base”

  1. With a whole new world looking out for partners, finding the right match is just a matter of time. • Ask me about how I made a million dollars in less than an hour.• Great cook wants to add some spice to your life.• If I could rearrange the alphabets I would arrange I and U together.• If you can read this you have passed the first test, if you can't then you better take a class or something.• Not looking for short term.• You have some explaining to do!