Replication Betn 2 database with null in some column

vyanku

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?

garak

Which SQL Server?
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).

vyanku

I am using SQL2005.

Do u mean that this can be done using import /export data I can create job and rin it after perticular inerval?

garak

For example. SSIS Packages can be sheduled. You can create these packages with Visual Studio (Busin. Intel). It was install. during install. SQL Server.

vyanku

Thanks.
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:

kriki

[Topic moved from Navision forum to SQL General forum]