Em Andamento

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

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: example number problem 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, fake source, scramble, fake program, ssn database, install ideal php, php form sql, database female, rodriguez, sql windows form, php sql form database, windows scripts, database scripts, software fake program, switching software

Acerca do Empregador:
( 109 comentários ) Bronx, United States

ID do Projeto: #2970034

Premiar a:

aweinstein

See private message.

$7 USD em 5 dias
(3 Avaliações)
2.3

13 freelancers estão ofertando em média $84 para este trabalho

springdotnetvw

See private message.

$63.75 USD in 5 dias
(137 Comentários)
7.2
avs99

See private message.

$34 USD in 5 dias
(38 Comentários)
6.2
Razaali75

See private message.

$42.5 USD in 5 dias
(17 Comentários)
4.1
jspsenthilvw

See private message.

$11.05 USD in 5 dias
(22 Comentários)
3.9
hetaneel

See private message.

$38.25 USD in 5 dias
(9 Comentários)
3.7
grzegorztwa

See private message.

$34 USD in 5 dias
(3 Comentários)
2.1
softwarexchange

See private message.

$42.5 USD in 5 dias
(3 Comentários)
2.2
ontargetvw

See private message.

$573.75 USD in 5 dias
(0 Comentários)
0.0
ashishkapoorvw

See private message.

$42.5 USD in 5 dias
(0 Comentários)
0.0
amethystvw

See private message.

$42.5 USD in 5 dias
(1 Comentário)
0.0
cgonzalezvw

See private message.

$80.75 USD in 5 dias
(0 Comentários)
0.0
kingsukvw

See private message.

$76.5 USD in 5 dias
(1 Comentário)
0.0