Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #NO REBUILD:
- (1) if needed, edit target in saved script: **MEDIDATA.SQLCLR.publish.sql** (attached below)
- (1.1) default is coder_v1 database, replace all instances of "coder_v1" if a different database target.
- (2) execute script against target via the command line.
- (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.
- (2.2) example (SQL Server authentication):
- sqlcmd -S localhost -d master -U username -P passord -i MEDIDATA.SQLCLR.publish.sql
- (2.2.1) for ActiveDirectory authentication, trusted connection (windows authentication/trusted)
- (2.2.1.1) -E
- (2.2.1.2) remove -U and -P
- (2.2.2) change server from "localhost" to target server, if not localhost
- (2.2.3) database (-d option) is not in affect, since the script already names the target database.
- #ADDITIONAL CODE
- (1) procedure to extract ODM from xml to discrete table (_CodingOdmValues)
- (2) procedure to retroactively compress ODMs, using Gzip algorithm.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement