Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Replication Betn 2 database with null in some column
vyanku
Member Posts: 791
I create two database having same datain SQL server for navision.
When I add some information in 1st database it should be replicate in 2nd database . But I want zero data in some columns and other columns should be replicated with data.
I used transactional replication but it will not work properly.
Which type of replication I should use?
How can I filter the columns as per my requirnment?
When I add some information in 1st database it should be replicate in 2nd database . But I want zero data in some columns and other columns should be replicated with data.
I used transactional replication but it will not work properly.
Which type of replication I should use?
How can I filter the columns as per my requirnment?
0
Answers
Transaction Repl. on 2000 transfer all columns on changed Record.
By 2005 only changed columns will be transfered.
So everey transaction (modify in an field) will be delivered.
If you will not transfer data that contains zero (not NULL) values (like decimal 0.00) you can't do this with transact. replication because both tables must have the same state. For this you can use SSIS (DTS).
Do u mean that this can be done using import /export data I can create job and rin it after perticular inerval?
The Problem is solved.
What I have done ,I create transactional replication and after this replication there are 3 store procedures update,delete,insert.I modify the update storeprocedure by passing the value null in some fields. And its working fine. \:D/ :whistle:
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!