We need to migrate a column of rtf-encoded text in SQL Server 2005 to a plain text field in a different table. Using Access, I can save the encoded text in a .rtf file, then open the file in Word and save it as a .txt, then read the .txt back into Access - Word strips out the rtf tags and returns a plain text file with embedded CR/LF. However, this is a time-consuming process (1000 records took around 20 minutes) and I have 160K records to process. Does anyone know how to do this more efficiently (e.g, without using Access and/or Word)? I thought about writing a .net app; however, I don't have the Visual Studio tools for Office, so I'm not sure if I can create and control a Word object from .net.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!