Activity overview
Latest activity by StephenMclean
DLM Dashboard and Different Versions of SQL Server
We have come across a situation where we have two databases that as far as SQL Compare is concerned are identical (Nothing Excluded when comparing)
Db2 was created as a backup and restore of Db1
A ...
Robert Clenshaw wrote:
Hi Stephen,
What output are you getting from the build step? I'd like to know if the build step is actually registering the schema with DLM Dashboard or if it's encountering a problem and not registering it. Another thing you could do to verify that the schema has been registered is to do the following -
Visit http://localhost:21060 in your browser
In the top menu click on Documents.
In the left hand pane click on SqlCompareSnapshots.
In the main window, look for a snapshot with the package name that you were trying to register it with.
If you can find it in the list then you've been able to register the schema and the problem is somewhere else.
Another thing I would do is to extract the nuget package to a blank folder and then use SQL Compare to compare it to the database - if there has been some sort of issue with the sync step then there might be a schema difference. That would be a possible explanation for the dashboard not recognising the schema as the one that you registered.
Thanks.
We have looked at the snapshots and the name is blank.
We compared the nugget package to the SYNC database and they were identical.
We're also seeing this in the Jenkins log at the end of the BUILD step:-
COMPLETED SUCCESSFULLY: Validating database state
STARTING: Publishing database package
Writing package to C:Program Files (x86)JenkinsjobsManzen Database TrunkworkspaceNewCIPackage.2.509.nupkg...
Written database package to C:Program Files (x86)JenkinsjobsManzen Database TrunkworkspaceNewCIPackage.2.509.nupkg
COMPLETED SUCCESSFULLY: Publishing database package
Registering schema with DLM Dashboard...
Done / comments
Robert Clenshaw wrote:
Hi Stephen,
What output are you getting from the build step? I'd like to know if the build step is actually registering the schema with DLM Dashboard or if it's encounteri...
In answer to Chris Lambrou's questions
* What version of DLM Dashboard are you using? You can find this at the bottom of each page. 1.6.1.440
* What version of SQL CI are you using? You can find this in the SQL CI output in the logs of your Jenkins builds sqlCI.exe -- Red Gate's SQL Continuous Integration v2.1.8.167 * What version or versions of SQL Server are you targeting? SQl Server 2008 R2
"are you certain that localhost actually refers to the DLM Dashboard instance that you think it does?" Jenkins, SQL CI, Octopus Deploy & DLM Dashboard are all running on the same machine. We tried using the IP Address but it made no difference / comments
In answer to Chris Lambrou's questions
* What version of DLM Dashboard are you using? You can find this at the bottom of each page. 1.6.1.440
* What version of SQL CI are you using? You can find th...
Integration with SQL CI
Our environment is Jenkins, DLM Automation Suite & Octopus Deploy
In the Command Line info for SQL CI when referring to the /dlmDashboardHost switch it states:
When you run the build step, SQL CI s...