Hi All
I have a production database containing a VARBINARY(MAX) field, as well as others. I need to build a routine that will generate a set of Insert statements from that table, so I can transfer the data to development environments. What's the best way to achieve this? I've had a look around Google but it hasn't yielded any results.
I've seen the way Redgate SQL Compare does it, it builds up a string containing an Insert statement and subsequent updates, is this the only way?
I'm unable to use the Backup and Restore method because the database has TDE applied, and I only want a subset of the data.
If anyone has any suggestions that would be much appreciated.
Cheers