Post reply

SQL 2k Replication - view to table

  • September 20, 2005 at 9:27 am

    #165331

    We would like to copy sensitive prod data into a devleopment environment and use a view to alter some of the sensitive rows. (incl. ssn's)

    We have views that will "scrub" the data and substitute ssn's with an alternate key for R.I.

    Some would like us to use replication to copy from our scrubbed views to our dev tables. Anyone have suggestions on how to accomplish this?

    Only ops has access to distributors on-site, including my laptop so I can't do much experimenting and have to back-seat drive.

  • September 20, 2005 at 11:20 am

    #591440

    Not sure, but I don't think you can use a view to "Replicate" the data thru sql server replication, it will only copy the table data.

    If you are just trying to make a copy but alter the ssn field, then just dts the data into your dev database and you can there use the view that does the "Scrub", or you can perform the scrub in your DTS Package.

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply