How to prepare a fake database via SQL of a working database for testing purposes for development
Posted on 2011-09-20
We would like to test our VB.NET developments on database with real data but not affect the production database.
We've been tweaking with the idea of making a copy of the production database, rearrange all sensitive data as: last names, addresses and invoices, payments amounts.
The problem we're having is the algorithm or logic of relating masters tables and their transactions tables.
What we're looking for is to have the same structure from the production database so we can developed on it. In addition, for validating the apps, the values of agings, historicals, and also to have it square off with their related tables.
We would liek to go about using SQL script since our DB are in MS SQL.