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 |
|
Corobori
Posting Yak Master
105 Posts |
 Posted - 2005-06-29 : 22:04:24
|
| Hi,Here is my situation: I have an application written in .NET using MSDE locally. My clients needs this application modified to use a centralized OR the MSDE locally. The difference being that some data on the server shouldn´t be displayed because they are confidential, that means I should erase the actual replacing them by XXXXs .Those confidential data are only updated and seen when the users will choose to work locally when working. At some stage those data need to be published so relations won´t be broken on the networked db.On the other hand some data will be updated on the server db and will need to be replicated to locally in db running MSDE.I have got no experience with replication so my question is: would replication do the work for me ?jean-lucwww.corobori.com |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-06-29 : 23:21:27
|
| what will replication do for you?replication will copy the data from the source to the destination, that's all...it will not encrypt the data, but you can set columns not to be replicated, or modify the insert,update sprocs for replication, these can be seen at the subscriber (destination) databaseHTH--------------------keeping it simple... |
 |
|
|
jkatsos
Starting Member
6 Posts |
Posted - 2005-06-29 : 23:25:55
|
| Sounds like you have two use cases.You need to get data stored on you main db to be replicated locally but some confidential data columns stripped out. Yes you can do this by using filters when you create your publication.The second case is that you need data that is changed locally to be sent up to the main db. You can use merge replication to do this. Be aware that you can get conflicts and when the same data is changed on both dbs, one will have to win so you need to set thosSo yes in should be able to be done |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2005-07-21 : 16:06:01
|
| I did something similar.We use replication to push data to another server for users to query against. Then I added another step to the replication job to update the Credit Card field to '1111 1111 1111 1111'. This allows users to know that orders were charged, but they cannot see CC numbers. |
|
|
|
|
|
|
Replication or other ?