Red Gate forums

RE: Slightly Different Error on Comparing Backup to Live DB

rsvalley — Fri, 24 May 2013 03:12:12 GMT

maybe you can find the best answer from me,come here.rsvalley is the best answer!

_______________________________________________________
cheap rs gold

RE: SQL Prompt 5 doesn't support Synonyms?

David Atkinson — Thu, 23 May 2013 21:33:36 GMT

You need to enable this in the Experimental Features, which is a menu item in the SQL Prompt menu in SSMS.

David Atkinson
Red Gate

RE: SQL Prompt 5 doesn't support Synonyms?

Mindflux — Thu, 23 May 2013 20:25:47 GMT

Hi. I am using 5.3.8.2 and it seems to support synonyms ok.

RE: Maintenance Window

Luis Martin — Thu, 23 May 2013 19:20:22 GMT

Thanks.!

Lost migration script in SSMS

AdamY — Thu, 23 May 2013 18:54:49 GMT

I recently created a migration script to cover some changes to a table and sprocs. When I committed the changes yesterday, the file disappeared from the "Migrations" tab of SQL Source Control. I have version 3.4.1.73 of SQL Source Control and I did check in these changes with the #ignorepolicies tag. I have restarted SSMS and rebooted my machine, but the issue persists. The only file that shows is one I committed 2 months ago.

It seems the only part broken is the SQL Source Control because...
[1] The script does show in TFS and is in my local TFS file directory.

[2] When using SQL Compare to create a change script, it does recognize the migration script and use it.

The Migration Scripts location is correct in SQL Source Control.

How do I get SQL Source Control to show the file again? Thank you for your help.

RE: Windows authentication in IIS 7

chriskelly — Thu, 23 May 2013 16:45:32 GMT

Thank you for your post.

Where are you trying to use Windows Authentication? It isn't entirely clear in your post.

The tool login has three user rules which do not support Windows Authentication in any way. But windows user accounts can be used for the actual monitoring.

But if you can clarify what you are trying to do, then I might be able to give a more specific answer.

RE: Registrering fails for database with federation

evaluator — Thu, 23 May 2013 14:47:35 GMT

Thanks for your response. I enabled logging and recreated the error:

Code:

The error message seems to be truncated in the log file as well.

I have discovered that both databases actually contain FEDERATED tables, and one of those registers fine. So I suspect that MySQL Compare requires more/different rights than MySQL Workbench and other applications of MySQL. Could that be true?

SQL Prompt 5 doesn't support Synonyms?

yuanw — Thu, 23 May 2013 13:50:05 GMT

I'm using SQL Prompt 5.3.2.2. All of Synonyms doesn't show. Which newer version can support Synonyms?

RE: Maintenance Window

Brian Donahue — Thu, 23 May 2013 12:53:31 GMT

You may want to visit the SQL Monitor user sugegstion forum:
http://sqlmonitor.uservoice.com/forums/91743-suggestions

This way the popularity of product suggestions is monitored so the most popular suggestions will be considered.

SQL Monitor currently allows only one time setting for the maintenance window that can be applied to the chosen days of the week.

SVN Keywords

aphillippe — Thu, 23 May 2013 10:44:45 GMT

SVN Keywords don't seem to be supported (I'm using v 3.2.0.27). There's a ticket on the feedback site (http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/805367-support-svn-id-keyword) but I thought I'd post here as well. Did SVN Keyword support ever get added or am I doing it wrong!?

thanks.