Skip to content

Instantly share code, notes, and snippets.

View GoEddie's full-sized avatar

Ed Elliott GoEddie

71 followers · 6 following
View GitHub Profile
@GoEddie
GoEddie / targetSqlVersion.cs
Created May 4, 2017 20:42
If you have an SSDT project in visual studio and want to get the version of sql it is targetting because everything is internal :( do this!
string GetTargetSqlServerVersion(){
var dte = (DTE)GetService(typeof(DTE));
var project = dte.ActiveDocument.ProjectItem.ContainingProject;
return project.GetType().GetProperty("Globals").GetValue(project).GetType().GetProperty("Parent").GetValue(project.GetType().GetProperty("Globals").GetValue(project)).GetType().GetProperty("DatabaseSchemaProvider").GetValue(project.GetType().GetProperty("Globals").GetValue(project).GetType().GetProperty("Parent").GetValue(project.GetType().GetProperty("Globals").GetValue(project))).GetType().GetProperty("Platform").GetValue(project.GetType().GetProperty("Globals").GetValue(project).GetType().GetProperty("Parent").GetValue(project.GetType().GetProperty("Globals").GetValue(project)).GetType().GetProperty("DatabaseSchemaProvider").GetValue(project.GetType().GetProperty("Globals").GetValue(project).GetType().GetProperty("Parent").GetValue(project.GetType().GetProperty("Globals").GetValue(project))))
}
@GoEddie
GoEddie / deploy.cmd
Last active August 29, 2015 14:07
use sqlpackager to deploy ssdt dacpac's
SET PATH=C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin;%PATH%
SET SourceDacpac=%1
SET Server=%2
SET Database=%3
SET DBUser=%4
SET DBPass=%5
SET SqlDeployScript=%6
SET Variables=%7
SET PublishProfile=%8