troubleshooting Question

How to Give Data to a Client without Giving them your Intellectual Property

Avatar of DaveKid
DaveKid asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
13 Comments5 Solutions223 ViewsLast Modified:
We have a client that "owns" the data on our server.   They are asking us for said data but we don't want to just give them a database backup as that we essentially be handing them a huge chunk of building the system themselves (which they are looking to do)

Any advice on how to give them a "data pull" without handing them the actual table structures and without it taking a ton of manual effort to "obfuscate" it?

Obviously, I know how to leave out the SP's and Functions but SP's can easily be generated automatically via scripts.
ASKER CERTIFIED SOLUTION
David Todd
Senior Database Administrator

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 5 Answers and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 5 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros