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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-16 : 20:33:57
|
Rajendran writes "Hi,
One of the projects that I am handling is a web based application involving SQL 7.0/ASP/IIS4.0 and MTS. One of the requirements of this project is as under :
The SQL server database will be live and on-line 24x7x365. Now there
is another SQL database which is not on-line and contains only some of the tables that the live one has. Data is being entered into this database on a reguler basis by data entry operators. Now I want to update the live on-line SQL Database with the data from the second SQL database while it is on-line. Users will be adding information to the
live database on-line. I can't simply append the data as it involves updating 5 to 6 tables which are all related. Also I am not using identity coloumns in any of my tables. I am using a seperate table for keeping track of the the last number in other tables.
What is the best way to do this? This updation will be done on a reguler basis and a VB application can be used.
Regards
Rajendran "
|
|
|
|
|
|
SQL Server