Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi,

How can I deploy the dll in sql server like a compiled dll in production server?

Thanks,
Posted
Comments
[no name] 29-May-14 9:46am    
You say "the dll" like we would have any idea what DLL you are talking about, or what you are trying to do, or what the actual problem would be.
Manikandan MAC 29-May-14 9:53am    
Actually, We will deploy the updated dll from the developing server to production server for the coding side(Front end), like-wise Can we deploy in SQL Server script deployment like to change the dll?

Now-a-days we are alter the DB by running the scripts. So is there any possible to change like a Dll along in DB?

Thanks
[no name] 29-May-14 10:22am    
Again, you say "the dll" like we would have any idea what "the dll" means. Do you have any idea how many "the dlls" there are in the universe? Or what script you think is going to "change the dll"?
Manikandan MAC 29-May-14 10:44am    
dll, which is in the Bin directory for every projects. eg <projectname.dll>

1 solution

No, you can't do that. The purpose of dll is totally different from sql script. You need to understand these terms properly.
A dll is Microsoft's implementation of the shared library concept and is works as a library for your project. Whereas your data in SQL Server resides in a .mdf file and no dll up-gradation kind of approach will work here. Either you need to execute the script or restore a backup file to get the changes applied to the production SQL Server. You can also attach/detach the .mdf file but it has a different purpose.

Hopefully, I have clarified the things. I believe, some google search can help clearing your doubts :)
 
Share this answer
 
Comments
Manikandan MAC 27-Mar-15 9:58am    
Thank you very much Giri

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900