Connecting Tech Pros Worldwide Help | Site Map

embedded SQL

BillG_sd
Guest
 
Posts: n/a
#1: Nov 22 '05
I'd like to embed MS SQL Server 2000 scripts into a resource DLL. When a client needs a backend update they just download this resource DLL and the upgrade utility links to the resource DLL & runs the latest script(s). Is there a way to do this?

According to MSDN docs, you need to use resgen to convert .txt files to resources, however, the format is very specific for the text file

ResourceName = Value

Obviously, this will not work with SQL Scripts. At runtime, I could load the scripts externally from text files, but I don't want to give the client (or a hacker) the ability to changes these scripts. There's got to be a way to embed them. Any suggestions?

-BillG_SD

Closed Thread