Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Question Unanswered: I'm looking for a Scrambling tool

    Hi.

    I need a tool for manipulating the data in my tables. I want:
    1. The tool doesnt' touch the primary key of the tuples in the table
    2. Mix the rest of the column, so, everybody'll never know which primary key correspond to the rest of columns.

    I don't know if I can do it with SQL.

    That is for testing.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Look at the ENCRYPT() function. You'll need to process each column value separately.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Yup...you want to create development data...what happends if the PK is an SSN..

    Do you need to scramble all of the elements?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •