Activity overview
Latest activity by JordanBentley
For those coming to this in the future, assuming no fix has been implemented in the software I found that I could add the database manually via SQL script and it picked everything up it needed. Once you see the database, just click the 'Scan for updated schema' link at it should begin to populate. Sample script below: INSERT INTO Redgate_SqlDataCatalog.dbo.Databases
(
[Name],
[InstanceId],
[DetectedAtUtc],
[Archived],
[Id],
[LastScannedUtc],
[ScanResultHash]
)
VALUES
(
N'<YOUR DATABASE NAME>',
<THE INSTANCE ID OF THE SERVER>,
N'<SOME DATE AND TIME>',
0,
<CONSTRUCTED ID FOR THE DATABASE>,
NULL,
NULL
);
INSTANCE ID OF THE SERVER Can be obtained by looking it up in the 'dbo.Instances' table. Or you can get it from the URL when you click into the server page, it will be a 19 digit number. CONSTRUCTED ID FOR THE DATABASE Not sure if this is a requirement but the ID of the database seems to be made up of the first 9 digits from the Instance ID then a random 10 digit number. This is the format I used and it worked. / comments
For those coming to this in the future, assuming no fix has been implemented in the software I found that I could add the database manually via SQL script and it picked everything up it needed. Onc...
SqlException occurred while fetching Databases for instance
Trying to see if this product will do what we want, added a couple of systems with no issue until I try our CRM system.Target is a SQL 2012 instance (11.0.7512.11) so should be compatible. Directly...