Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Maintaining a database copy

Author  Topic  askar Starting Member 1 Post Posted - 2009-10-07 : 05:30:31 We have desktop application in VB which is using SQL server 2000 database. The application is being used for years now. Recently we have developed this application in to a web application.Now it is time to deploy this web application. There is no change in functionality in the new web application. The web application uses a new database with a minor change in structure with respect to field names in couple of tables. The client is ready to use the new web application so long as , in case of any problem with new appliocation, he is able to continue with the old desktop application. This means that we should be able to switch between the databases, ensuring latest data is available in the selected database. I was thinkng of following 1. whenver there is need, copy yhe source dataabse in to destination database entirely (taking care of identity columns etc) 2. Use triger to effect the changes in the 'other' table. I would like to know if there is any other better/efficient methods to achieve the above requirement. Thanks P.S : I hope I have posted this on right forum!