Home Forums Programming CLR Integration and Programming. How To Generate the deployment script wiht the binary string? RE: How To Generate the deployment script wiht the binary string?

  • March 21, 2012 at 7:58 am

    #1462146

    Tom Brown (3/21/2012)

    If you select the Build...Deploy option in VS (at least in VS 2010), then Visual studio creates the deployment .SQL in the bin/debug or bin/release directory along with your DLL. Just edit that file to create your deployment script.

    However you do need a local database where the deployment will work.

    Or you can load the assembly into a local database as a DLL file, then select the binary from sys.assembly_files - the content field is the binary you are looking for.

    Thanks Tom;

    I also found out after this post that you can right click and script the Assemblies in SSMS;

    Embarssingly, I was creating the scripts like that manually....loading the dll into a varbinary, selecting it to script....copy paste into my model...

    i learned a little bit after this one.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!