New To Replication

I am a software developer who has been tasked with setting up replication for one of our clients. I have about 1 week of experience working with replication, so any help would be appreciated.
My situation:
5 databases:
Production - All sales transactions go into here
Corporate - Used to report on everything in the Production DB
Site A - Filtered for Site A data
Site B - Filtered for Site B data
Site C - Filtered for Site C data
All connections must be two-way (Data changed at Site A most propagate back through Corporate to Production, data entered at Production -> Corporate -> Site A\B\C)
I want the Corporate DB to be the publisher and Production, Site A\B\C to be subscribers to keep the load off Production.
The issues I have are:
Filtering the data to Sites A\B\C
Default values are being stripped off columns during replication
Data is not being propagated accuratly (Data entered at production replicated to Corporate, then the data is deleted at Corporate and at Production).
I have tried several combinations of Merge and Transactional Replication and nothing works as needed.
Thanks,
David
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
David,
one topology that should solve your issues:
Production publishes everything to Corporate using merge.
Corporate publishes to SitesA-C (3 subscribers) using merge with dynamic
filters.
This setup is known as republishing, as Corporate is both a publisher and a
subscriber.
HTH,
Paul Ibison

New job opportunities

One of our clients is in need of following requirements .

OM Designer:-

Location: Mountainview,CA
Duration: Long-term
Startdate: ASAP
No of positions: 6

Skills
8 years of experience
Strong Functional Skills in Order Management and Distribution Modules.
Atleast 3 Implementation experience in Order Management.
Proven experience in designing Business solutions to Customer in OM
based on Business problems or requirements

OM & AR Techno-Functional:-

Location: Mountainview,CA
Duration: Long-term
Startdate: ASAP
No of positions: 6

Skills
6 years of experience
Exclusive Strong Techno-Functional Skills in Order Management and
Distribution Modules & Accounts Receivables modules.
Document Technical Designs, Unit Test Cases and Code.
Maintain Software written by yourself and others
Ensure Code is high Quality.
Good verbal and written communication skills
Solid software engineering skills.
Oracle Development tools - PLSQL, Forms, Reports, Workflow,XML.
Implementation Experience in Oracle Modules: OM, AR.
Nice to have Exposure to tools: Kintana, Teamtrack

OM & SCM Techno-Functional:-

Location: Mountainview,CA
Duration: Long-term
Startdate: ASAP
No of positions: 6

Skills
Strong Techno-Functional Skills in Order Management and Distribution
Modules & Supply Chain (Inv, PO, Shipping, AR) modules.
Document Technical Designs, Unit Test Cases and Code.
Maintain Software written by yourself and others
Ensure Code is high Quality.
Good verbal and written communication skills
Solid software engineering skills.
Oracle Development tools - PLSQL, Forms, Reports, Workflow,XML.
Implementation Experience in Oracle Modules: Inventory, Purchasing(Drop
Ship PO), Third Party Order Fulfillment, EDI Integration.
Nice to have Exposure to tools: Kintana, Teamtrack
6

I2C/AR Techno-Functional:-
Location: Mountainview,CA
Duration: Long-term
Startdate: ASAP
No of positions: 4

Skills
6 years of experience
Minimum 5 years experience in AR as Techno-Functional Consultant
Project experience in and comprehensive knowledge of AR tables and
APIs.
Functional understanding of the AR flow and able to translate into
technical terms
Functional understanding of the AR flow to GL (revenue recognition,
accounting entries) and able to translate into technical terms.
Functional understanding of invoice, credit memos, debit memos,
receipts and chargebacks and able to translate into technical terms
Project experience and comprehensive knowledge of AR Tables and APIs

F2M/P2P Techno-functional:-

Location: Mountainview,CA
Duration: Long-term
Startdate: ASAP
No of positions: 6

Skills
6 years of experience
strong Techno-Functional Skills in GL, PA, CM, FA, AP, PO, iPayables

Release Coordinator:-
Location: Mountainview,CA
Duration: Long-term
Startdate: ASAP
No of positions: 1
Skills
5 years of experience
Detailed knowledge and proven experience with Oracle AOL, Kintana and
VSS(configuration management).
1
Very Good Communication & interpersonal skills
Release management for non production environments(DEV, QA and UAT)
- Coordinating DEV and QA team for Kintana releases
- Kintana Package migration activities(code deployment)
- Submitting builds for migration
- Code Retrofit activities(planning and coordination only)
- Resolving release/code migration issues by discussing with
Engineering and SCM teams
Coordination and follow up with SCM(s/w configuration mgmt) teams for
Patches and environmental issues

Performance Tuning Expert:-

Location: Mountainview,CA
Duration: Long-term
Startdate: ASAP
No of positions: 1

Skills
6 years of experience
strong experience in oracle apps 11i performance tuning with expertise
in distribution and

ATG Dynamo Developer:-

Location: Minneapolis, MN
Duration: Long-term
Startdate: ASAP.

Skills
* Strong experience in JAVA
* ATG Dynamo App framework
* JSP
* Servlets
* Personalization
* Profile management.
* Good to have (ATG Portal Admin)
* Good Communication Skills

If you are interested in the above opportunity, please send your
updated resume with followingdetails

Full Name:
Availability:
Salary/rate:
Contact No.:
Current Location:
Visa Status:

Reply ASAP,
Thanks and Regards,
Kalyan Mudda
Spectraforce Technologies Inc.
919-846-7975 x 302
919-341-8358.
kmudda@.spectraforce.com
www.spectraforce.comRadhesh Reddy (radheshreddy@.gmail.com) writes:
> One of our clients is in need of following requirements .

I hope you don't plan to ask any SQL questions for the next 90 days. In
that case, I will not see them, as you just entered my kill file.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Are you phishing for useful info by any chance? Google & Oracle don't
recruit like that!

*** Sent via Developersdex http://www.developersdex.com ***

New domain

I have a client that has been running 2 separate domains (same subnet). An
NT4 domain and a W2K3 domain. All clients have been added to the W2k3
domain. The NT domain now consists of a PDC, a BDC and 2 SQL 2000 servers
running W2k. My plan is to simply downlevel (remove from NT domain add to
workgroup) 2 SQL servers and then add them to to W2K3 domain. This would
render PDC and BDC with out use and we could do whatever with them. I am
wondering if this will cause any issues with SQL servers that I am not
forseeing. Insights very much appreciated.I cannot see any problems switching domain belonging as long as you dont
rename the SQL servers hostnames. You might also want to keep an eye on
which account is running the SQL services.
----
---
Johan Engdahl
CCSA, CCSE, CCA, MCP | johan AT firewall1 DOT nu | http://www.firewall1.nu
"Laurie" <Laurie@.discussions.microsoft.com> wrote in message
news:5E47BEEF-9BBD-43F6-B99F-BEAAEA4643A3@.microsoft.com...
>I have a client that has been running 2 separate domains (same subnet). An
> NT4 domain and a W2K3 domain. All clients have been added to the W2k3
> domain. The NT domain now consists of a PDC, a BDC and 2 SQL 2000 servers
> running W2k. My plan is to simply downlevel (remove from NT domain add to
> workgroup) 2 SQL servers and then add them to to W2K3 domain. This would
> render PDC and BDC with out use and we could do whatever with them. I am
> wondering if this will cause any issues with SQL servers that I am not
> forseeing. Insights very much appreciated.
>