asifsalahuddin
March 31st, 2001, 12:38 PM
Dear All,
I need to write up a brief technical description on replicating data from one database (master copy) onto a second database (database copy).
Basically, the databases will be MS SQL Server 7.0s. The master database will reside on a local server of a company and a copy of it will be hosted at a hosting company's server. The idea is that the master database can be accessed internally over the network via a VB front-end. Data from this master database can then be replicated daily onto the other database at the hosting company. This database copy will be accessed over the internet via the company website.
Issues which I would appreciate advice on / need to clear up so I can briefly comment on are:
- How will the two databases be synchronised / have data replicated from the main db to the other? (I understand this will involve ODBC, but how will this be used?)
- Will there be some kind of script/program running on the main db which will automatically do this every day? What will this be written in and where would it reside?
- Is this a complicated procedure or a straight forward one?
- How long would the sync./replication take every day?
- Can it be arranged such that data is replicated differentially? (i.e. only new data is copied over - is this easy to do?)
- Are there any other issues involved which should be mentioned?
Thanks.
Asif.
I need to write up a brief technical description on replicating data from one database (master copy) onto a second database (database copy).
Basically, the databases will be MS SQL Server 7.0s. The master database will reside on a local server of a company and a copy of it will be hosted at a hosting company's server. The idea is that the master database can be accessed internally over the network via a VB front-end. Data from this master database can then be replicated daily onto the other database at the hosting company. This database copy will be accessed over the internet via the company website.
Issues which I would appreciate advice on / need to clear up so I can briefly comment on are:
- How will the two databases be synchronised / have data replicated from the main db to the other? (I understand this will involve ODBC, but how will this be used?)
- Will there be some kind of script/program running on the main db which will automatically do this every day? What will this be written in and where would it reside?
- Is this a complicated procedure or a straight forward one?
- How long would the sync./replication take every day?
- Can it be arranged such that data is replicated differentially? (i.e. only new data is copied over - is this easy to do?)
- Are there any other issues involved which should be mentioned?
Thanks.
Asif.