SQL Replication

[bnageshrao]

Hi
I am working at a client's site where they have a sql database residing on SQLServer 7.0 for HR Services and they have peoplesoft database residing on SQLServer 2000. They are still using their old HR Services system for some applications. They want some of the data(like EMPLID, LASTNAME, FIRSTNAME, PHONE ....... about 20 fields) to be inserted in their old database concurrently when user enters thru peoplesoft online panel. Otherwise they have to key in the same data to enter it in the old database. Does any one know how to do this, because both databases are sitting on SQLserver, there must be a easier way. If any one can shred some light to this I really appreciate. Thanks in advance.
Regards
Banur

 

[ThomVF]

You could use stored procedures to do this.

For example, a trigger could be set up to replicate an insert/update or delete on the older system, provided you have key values in the new system that allow you to find the corresponding record in the old (for inserts, you obviously wouldn't have to worry about that).



SQL server also has "Transactional Replication" features which can be implemented from Enterprise Manager. This is a series of T-Sql scripts that provide replication.

Check out the Books Online under REPLICATION for details.
"Helping others to help themselves..."
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[sguslan]

Also, SQL7/2000 has Merge replication which syncronizes data update/inesrts/deletes from/to both machines.

Read on :

http://www.swynk.com/friends/achigrik/ValidMR.asp#part_1

 

If somebody can give me a detailed instructions on achieving this, I really appreciate. Suppose if you have to write a database trigger, then a sample code of it and then where to attach it. Then when it triggers how does it go to the other database residing on SQL server 7.0, do you need to connect it to the otherdatabase and if so what commands are used for it. Thanks in advance
Regards
Banur