Comments
Sort by recent activity
Hello,
Thanks for your post.
Connecting to SQL instances on an availability group shouldn't be a problem for SQL Monitor -- you should be able to use <windowsclustername>* as the address. Is that what you were trying?
If that doesn't work, can you try adding <windowsclustername><sqlinstance1>, then <windowsclustername><sqlinstance2>, etc.?
Please let me know how that goes.
Regards,
Evan / comments
Hello,
Thanks for your post.
Connecting to SQL instances on an availability group shouldn't be a problem for SQL Monitor -- you should be able to use <windowsclustername>* as the address. Is that ...
Hello,
After doing a bit more research and testing, it actually appears the only way to do this is to add each node individually. Sorry about the inconvenience.
Thanks,
Evan / comments
Hello,
After doing a bit more research and testing, it actually appears the only way to do this is to add each node individually. Sorry about the inconvenience.
Thanks,
Evan
Hi Nikhi,
Thanks for your post.
The SQL processes should actually show up for SQL-level alerts regardless of whether you have trace turned on, so it sounds like you might have a deeper issue.
Can you send in your log files to support@red-gate.com and reference case 30640? You can find the log files by going to configuration>about and clicking "retrieve all log files".
Regards,
Evan / comments
Hi Nikhi,
Thanks for your post.
The SQL processes should actually show up for SQL-level alerts regardless of whether you have trace turned on, so it sounds like you might have a deeper issue.
Can y...
Hello,
Thanks for your post.
I just tried reproducing your behavior and wasn't able to.
I created two databases, a and b, and ran these scripts on them: CREATE TABLE [dbo].[table 1]
(Column1 INT,
Column2 INT,
Column3 INT,
Column4 INT)
GO
EXEC sp_addextendedproperty N'MS_Description', N'Description 1', 'SCHEMA', N'dbo', 'TABLE', N'Table 1', 'COLUMN', N'Column1'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Description 2', 'SCHEMA', N'dbo', 'TABLE', N'Table 1', 'COLUMN', N'Column2'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Description 3', 'SCHEMA', N'dbo', 'TABLE', N'Table 1', 'COLUMN', N'Column3'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Description 4', 'SCHEMA', N'dbo', 'TABLE', N'Table 1', 'COLUMN', N'Column4'
GO
CREATE TABLE [dbo].[table 1]
(Column1 INT,
Column2 INT,
Column3 INT,
Column4 INT)
GO
EXEC sp_addextendedproperty N'MS_Description', N'Description 1', 'SCHEMA', N'dbo', 'TABLE', N'Table 1', 'COLUMN', N'Column1'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Description 4', 'SCHEMA', N'dbo', 'TABLE', N'Table 1', 'COLUMN', N'Column4'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Description 2', 'SCHEMA', N'dbo', 'TABLE', N'Table 1', 'COLUMN', N'Column2'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Description 3', 'SCHEMA', N'dbo', 'TABLE', N'Table 1', 'COLUMN', N'Column3'
GO
Then I compared them in SQL Compare 10.7 and they did not show up as differences.
Is there anything else you're doing that could explain different behavior? Are you using the default comparison options?
Thanks,
Evan / comments
Hello,
Thanks for your post.
I just tried reproducing your behavior and wasn't able to.
I created two databases, a and b, and ran these scripts on them:CREATE TABLE [dbo].[table 1]
...
Hello,
Thanks for your post.
It looks like we changed some behavior around sequence objects for the SQL Compare 11 beta (bug reference SC-6837). Can you try that version to see if it behaves the way you'd like?
You can find the beta here: http://www.red-gate.com/messageboard/vi ... hp?t=20075
Regards,
Evan / comments
Hello,
Thanks for your post.
It looks like we changed some behavior around sequence objects for the SQL Compare 11 beta (bug reference SC-6837). Can you try that version to see if it behaves the w...
Hello,
Thanks for your post.
That does seem like a source control scripts folder. You should be able to use SQL Compare with that folder as a source to create a new database with the same objects. To do this, you'll select the "source control" radio button in the project settings, then select "scripts folder" and put in the path to your folder. On the target side, select "database", then specify a SQL instance and choose "Create Database".
In theory, you might be able to achieve the same thing in SQL Source Control by linking a blank database to that folder and doing a "get latest", but that's not recommended and is a lot clumsier to troubleshoot.
Hope that helps.
Thanks,
Evan / comments
Hello,
Thanks for your post.
That does seem like a source control scripts folder. You should be able to use SQL Compare with that folder as a source to create a new database with the same objects....
Hello,
Are you referring to SQL Data Compare?
If so, is the tables & views tab completely empty, or does it show table names that aren't mapped to each other?
We have a ticket open for you (reference 24216), so feel free to respond to the support email and I'm happy to help you there.
Thanks,
Evan / comments
Hello,
Are you referring to SQL Data Compare?
If so, is the tables & views tab completely empty, or does it show table names that aren't mapped to each other?
We have a ticket open for you (referen...
Hello,
I just did some testing and it appears this works better in the 11.0 beta. Can you try using that version to see if that helps? You can get more information on the beta here: http://www.red-gate.com/messageboard/vi ... hp?t=20075
Thanks,
Evan / comments
Hello,
I just did some testing and it appears this works better in the 11.0 beta. Can you try using that version to see if that helps? You can get more information on the beta here: http://www.re...
Hello,
Thanks for your post.
That does sounds like it's a corrupted installer. If you're trying to install from a network location, can you try moving it locally and re-running? You might also want to try running the installer explicitly as administrator.
If that doesn't help, can you try re-downloading from here? http://www.red-gate.com/dynamic/product ... e/download
Thanks,
Evan / comments
Hello,
Thanks for your post.
That does sounds like it's a corrupted installer. If you're trying to install from a network location, can you try moving it locally and re-running? You might also wa...
Hi Adam,
Thanks for your post.
It sounds like you might be interested in the /include switch -- you can find more details here: http://documentation.red-gate.com/displ ... ression%3E
I'm not entirely sure I'm understanding what you're trying to achieve, so if you can elaborate a bit on your goals, I'm happy to go into more detail on how to use the command line to achieve those goals.
Thanks,
Evan / comments
Hi Adam,
Thanks for your post.
It sounds like you might be interested in the /include switch -- you can find more details here: http://documentation.red-gate.com/displ ... ression%3E
I'm not entire...