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 |
|
syedalimurtuza
Starting Member
4 Posts |
 Posted - 2008-04-04 : 11:16:48
|
| Hello all gurus out there.I'm an entre level junior programmer. My question is kind of confusing but I'll try to put it as simple as I can.First we have a main table called "job1". This table consists the order information. The file_id is the unique id and the primary key for this table. This table also pertains other information such as customer data (max limit 5), job data etc. This table is actively (non-stop) used throughout the day. We have a non-interactive process which will take customers information from the main table and insert into the child table table "jobcust". Jobcust would have file_id, cust, cust_type. For example, if Job1 table had fiel_id=100 and cust1="Tom" and Cust2="David", now Jobcust will have two records file_id, cust1 and file_id,cust2. The main problem is the child table needs to be updated right away and our non-interactive process is good at doing that.. but it is causing a major DATA LATENCY. I would like to ask you all, if you know any better way of doing this without any process.. like in the back end with a trigger/procedure or something like that. All you help is appreciated.Thanks much. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-04 : 11:45:11
|
| you can't do replication in same instances in same server.If you need to replicate in other server with child table name,then you can do transactional replication since you already have primary. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-04 : 11:45:31
|
quote:
Originally posted by sodeep
you can't do replication in same instances in same server.If you need to replicate in other server with child table name,then you can do transactional replication since you already have primary key.
|
|
|
|
syedalimurtuza
Starting Member
4 Posts |
Posted - 2008-04-04 : 13:38:36
|
Thanks for the reply. But as you know I'm an entry level IT guy, can you please explain it in simple terminology.Thanks.quote:
Originally posted by sodeep
you can't do replication in same instances in same server.If you need to replicate in other server with child table name,then you can do transactional replication since you already have primary.
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-04 : 13:50:53
|
| What I am saying is you can do replication between two instances on same server or between 2 servers. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-05 : 21:56:31
|
| Take look at trigger. |
|
|
|
|
|
|
|
|
Parent/Child table replication