Completed

SQL 2000 Scripts

I need SQL 2000 Scripts to scramble table's fields.

I have a SQL 2000 database with 18 tables. The main table contains 18 columns. Among them the columns: Counselor, SocialSecurity, RecordNumber, MedicaidNumber, FirstName, and LastNameSN fields, etc. The remaining 17 tables contain a common field (RecordNumber).

I want to scramble the records (Counselor,SocialSecurity, RecordNumber, MedicaidNumber, FirstName, and LastNameSN) in the main table to create a parallel database with fake data.

The problem is that all tables are linked by the RecordNumber in a "One to Many" relationship. For example, if a RecordNumber is changed from 123456 to 562346 in the main table the corresponding record in the remaining 17 tables must be assigned the same number (562346).

The remaining 17 tables contain diferent data, that do not need to be scrambled. Just the RecordNumber.

The ideal solution should first switch all records and then scramble the data. For example:

Switching LastNames: John Doe to John Rodrigues. Sex Male

Switching SSNs: John Doe ssn 123-56-4567 to John Rodriguez ssn 874-32-9874. Sex Female

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

All windows platforms

Skills: Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL

See more: example of number problem with solution, data source sql, counselor, sql database relationship, php 123 4567, php sql 2000, sql run package, want 2000, sql problem, switch engineering, windows program switching, sex male, fake source, scramble, fake program, ssn database, install ideal php, sex female, sex working, php form sql

About the Employer:
( 109 reviews ) Bronx, United States

Project ID: #2970034

Awarded to:

aweinstein

See private message.

$7 USD in 5 days
(3 Reviews)
2.3

13 freelancers are bidding on average $84 for this job

springdotnetvw

See private message.

$63.75 USD in 5 days
(137 Reviews)
7.2
avs99

See private message.

$34 USD in 5 days
(38 Reviews)
6.2
Razaali75

See private message.

$42.5 USD in 5 days
(17 Reviews)
4.1
jspsenthilvw

See private message.

$11.05 USD in 5 days
(22 Reviews)
3.9
hetaneel

See private message.

$38.25 USD in 5 days
(9 Reviews)
3.7
grzegorztwa

See private message.

$34 USD in 5 days
(3 Reviews)
2.1
softwarexchange

See private message.

$42.5 USD in 5 days
(3 Reviews)
2.2
ontargetvw

See private message.

$573.75 USD in 5 days
(0 Reviews)
0.0
ashishkapoorvw

See private message.

$42.5 USD in 5 days
(0 Reviews)
0.0
amethystvw

See private message.

$42.5 USD in 5 days
(1 Review)
0.0
cgonzalezvw

See private message.

$80.75 USD in 5 days
(0 Reviews)
0.0
kingsukvw

See private message.

$76.5 USD in 5 days
(1 Review)
0.0