Advertisement
Guest User

Untitled

a guest
May 5th, 2015
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. #NO REBUILD:
  2. (1) if needed, edit target in saved script: **MEDIDATA.SQLCLR.publish.sql** (attached below)
  3.  
  4. (1.1) default is coder_v1 database, replace all instances of "coder_v1" if a different database target.
  5.  
  6. (2) execute script against target via the command line.
  7.  
  8. (2.1) the wait time to open the large script file in sql server management studio is not recommended. the studio will lock up for 30+ minutes.
  9.  
  10. (2.2) example (SQL Server authentication):
  11.  
  12. sqlcmd -S localhost -d master -U username -P passord -i MEDIDATA.SQLCLR.publish.sql
  13.  
  14. (2.2.1) for ActiveDirectory authentication, trusted connection (windows authentication/trusted)
  15.  
  16. (2.2.1.1) -E
  17.  
  18. (2.2.1.2) remove -U and -P
  19.  
  20. (2.2.2) change server from "localhost" to target server, if not localhost
  21.  
  22. (2.2.3) database (-d option) is not in affect, since the script already names the target database.
  23.  
  24. #ADDITIONAL CODE
  25. (1) procedure to extract ODM from xml to discrete table (_CodingOdmValues)
  26.  
  27. (2) procedure to retroactively compress ODMs, using Gzip algorithm.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement