Comments
Sort by recent activity
Hello @Derrick, Thanks for reaching out. Can you provide more details with what you mean by enabling PKI with the integrated authentication? Are you referring to TLS/SSL or self-signed certificates? Regarding integrated authentication on IIS, please see below for information with enabling Basic Authentication in IIS. A default domain and realm can be specified. Access rights are given to users who have access rights to SQL Monitor’s web folder:
Official instructions: https://technet.microsoft.com/en-us/library/cc772009(WS.10).aspx
Personally, I find this set of instructions more helpful than the official one: http://manual.aspdotnetstorefront.com/p-1614-enabling-windows-authentication-in-iis7.aspx
It’s very important to configure the site to use SSL. (See second link above)
I hope this answer helps you out. Kind regards, David Dang Product Support Engineer / comments
Hello @Derrick,Thanks for reaching out. Can you provide more details with what you mean by enabling PKI with the integrated authentication? Are you referring to TLS/SSL or self-signed certificates?...
Hi @hroberts, Thanks for the follow up! I'm glad that reverting to a previous version of SQL Prompt helped for you. I am not entirely sure why SQL Prompt may take longer in your environment as I was not able to replicate the issue in my environment. As environmental factors can affect performance of SQL Prompt, it may be difficult to pinpoint what were the exact causes of the issue. With that said, if you don't mind sharing the log files, I would be interested in seeing if the logs may contain any useful information. https://documentation.red-gate.com/sp/troubleshooting/finding-the-sql-prompt-log-files Kind regards, David Dang / comments
Hi @hroberts,Thanks for the follow up! I'm glad that reverting to a previous version of SQL Prompt helped for you. I am not entirely sure why SQL Prompt may take longer in your environment as I was...
Hi @hroberts, Thanks for sharing the logs. I do notice a difference in time at the point where SQL Prompt seems to be taking longer to decrypt objects. Do you have encrypted objects in your databases? Based on our SQL Prompt release notes, I don't see any changes that would affect this issues moving from 10.4.6 to 10.4.7. Although, as a workaround if you were to ever encounter this issue again, would be to uncheck the option to "Decrypt encrypted objects" in SQL Prompt > Options > Suggestions > Behavior > Encrypted Objects. I hope this was helpful! Don't hesitate to reach back out if you have any other questions. Kind regards, David Dang Product Support Engineer / comments
Hi @hroberts,Thanks for sharing the logs. I do notice a difference in time at the point where SQL Prompt seems to be taking longer to decrypt objects. Do you have encrypted objects in your database...
Hello @hroberts, I unfortunately haven't been able to reproduce (there does seem to be a short delay for me though only for a few seconds). Can you please check the following below to see if it helps: - Does it make any difference if you disable suggestions and code analysis (from the SQL Prompt menu) and also disable tab history (SQL Prompt>Options>Tab History) before opening the query? - What SQL Server version are you connected to? - To confirm, if you revert to the previous SQL Prompt release, does the issue go away for you? https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.4.6.16406.exe Kind regards, David Dang Product Support Engineer / comments
Hello @hroberts,I unfortunately haven't been able to reproduce (there does seem to be a short delay for me though only for a few seconds).Can you please check the following below to see if it helps...
Hello @rdaunce, Thanks for sharing your feedback. I've confirmed that running /MakeScripts just creates a copy of the source. Essentially copying the scripts folder and pasting yields the same results. If you do decide to upgrade to a later version of SQL Data Compare, /MakeScripts will no longer create copies of the file as you've noted. Although, the workaround is to run a copy command or manually copying the directory over. Please don't hesitate to let me know if you have any questions or concerns. Kind regards, David Dang Support Engineer / comments
Hello @rdaunce,Thanks for sharing your feedback.I've confirmed that running /MakeScripts just creates a copy of the source. Essentially copying the scripts folder and pasting yields the same result...
Hello @rdaunce, Thanks for your patience. As a quick follow up, I've confirmed with our development team that the old SqlDataCompare.exe /makescripts would have created a copy of the original folder and changes to the command line in later versions has likely caused a regression in this functionality. Is there a specific use case for this as it seems like copying the folder would be equivalent to the old /makescripts? In addition, I hope the workaround of either copying the folder or using an older version of SQL Data Compare would work for you. Please don't hesitate to reach out if you have any other questions. Kind regards, David Dang Product Support Engineer / comments
Hello @rdaunce,Thanks for your patience. As a quick follow up, I've confirmed with our development team that the old SqlDataCompare.exe /makescripts would have created a copy of the original folder...
Hello @rdaunce, Unfortunately, I was not able to reproduce this issue on my end. When running the /MakeScripts option with SQL Data Compare, does the directory contain any object creation scripts or does it create an empty directory? Does the directory contain any newly created files while SQL Data Compare is running from command line? If you add /LogLevel:Verbose, this will generate a log file at C:\Users\<user name>\AppData\Local\Red Gate\Logs\SQL Data Compare that may provide answers as to why the scripts are not created. Can you please send over this log file? Kind regards, David Dang Product Support Engineer / comments
Hello @rdaunce,Unfortunately, I was not able to reproduce this issue on my end. When running the /MakeScripts option with SQL Data Compare, does the directory contain any object creation scripts or...
Hello @davidf, Thanks for your question. Depending on the operations that are being performed by the script we may need to drop and recreate indexes or constraints. If you can provide an example, I may be able to provide more information on why specifically in your case this is occurring. Thank you, David Dang Product Support Engineer / comments
Hello @davidf,Thanks for your question. Depending on the operations that are being performed by the script we may need to drop and recreate indexes or constraints. If you can provide an example, I ...
Hi @davidf, SQL Compare can only create deployment scripts using a source against a target. If you are able to run a comparison between your database (source) and your customer's database (target), then you should be able to create a deployment script that will replace what your customers may have added to the table. I hope this answer helps you out! Don't hesitate to let me know if you have any other questions. Kind regards, David Dang / comments
Hi @davidf, SQL Compare can only create deployment scripts using a source against a target. If you are able to run a comparison between your database (source) and your customer's database (target),...
Hello @davidf, Unfortunately, you can't filter on index differences on SQL Compare. It has to be done on a table level since the indexes are part of the table. If you are okay with deploying all table differences (which would include the indexes), you can deploy "source only" and "in both but different" differences. Kind regards, David David Product Support Engineer / comments
Hello @davidf,Unfortunately, you can't filter on index differences on SQL Compare. It has to be done on a table level since the indexes are part of the table. If you are okay with deploying all tab...