Author Topic: CLR and SQL Server (express 2008 R2)  (Read 2197 times)

stanl

  • Pundit
  • *****
  • Posts: 939
CLR and SQL Server (express 2008 R2)
« on: January 08, 2014, 07:45:29 am »
Attached is a script that uses WB's CLR to create an xml schema file from a SQL Server Database. The oledb classes in the .NET Framework are not a huge leap from COM ADO, and results are delivered very fast.

Deana

  • Wilson WindowWare Tech Support
  • Pundit
  • *****
  • Posts: 1183
  • WinBatch® can do it.
    • WinBatch Tech Support Database
Re: CLR and SQL Server (express 2008 R2)
« Reply #1 on: January 08, 2014, 08:53:30 am »
Stan,

Thank you for sharing your code. I have placed it in the Tech Database in hopes that it might be useful to the next user: http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/tsleft.web+WinBatch/dotNet/System_Data+Create~an~XML~Schema~File~from~a~SQL~Server~Database.txt
Deana F.
Technical Support
Wilson WindowWare Inc.