Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best Practices to Ensure Working with Dev DB?
Message
From
22/11/2011 14:37:30
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01529519
Message ID:
01529591
Views:
34
>Are there any other ideas or best practices for this? There is no such thing as too paranoid here!

I'd suggest:

1. Put a copy of the data, and the sanitizing program, on the same physical computer
2. Move the computer to a location where all of its sides are visible e.g. on top of a desk, don't have it hidden under a desk/table
3. Disconnect that computer from the network - unplug the network cable. Or, if it's a wireless connection on a laptop, physically turn off the wireless adapter with the slider switch/keystroke combination, and/or temporarily disable the adapter in Windows. Confirm that the adapter is disabled
4. Run the sanitizing program

This may sound like overkill, but it isn't. There's nothing like being able to point at a computer, and show (to your client/boss etc.) that it's physically not capable of accessing the production DB, before running a test process that can make major changes to data.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform