I have been tasked to copy a Production Table and its contents to Test. Even though I’m not a DBA, I could probably extract the data, load it to Microsoft Access and then Export it to the Test Database. But in this case, there’s a “BLOB” Data Type on the Production Table and I think that’s going to mess up my thinking here.
Is there any easy way to copy a Production Table and its contents that contain a “BLOB” Data Type down to our Test Database without having to get a DBA involved here???
I appreciate your review and welcome a response.
Thanks in advance for your review and hopeful for a reply.