7bdc03d0   
   XPost: microsoft.public.dotnet.languages.csharp   
   From: esquel@sommarskog.se   
      
   Joe Cool (joecool1969@live.com) writes:   
   > I am in the process of converting a VB.NET project that I use for   
   > consulting work with a former (and hopefully soon to be repeat)   
   > employer tp C#.NET. When originally designed, their software was based   
   > on SQL7. Currently their software supports SQL2005. One key table in   
   > their database is a table of images and (not sure if it still does)   
   > but legacy databases utilize the image datatype to store images. With   
   > SQL7 I used a SQL command line utility called TEXTCOPY to extract the   
   > binary content of image columns to a JPG file.   
      
   Do you need to connect to the legacy databases?   
      
   On which version of SQL Server do they run on?   
      
   Note that it is only if you need to connect to them, and if they run on   
   older versions of SQL Server you need to bother. If they run on SQL 2005,   
   you can say convert(varbinary(MAX), imgcol) and your done.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)