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
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