Best Of
Re: SQL Compare 15.3.11.27029 Error: Input string was not in a correct format
This is the solution. I had to launch VS as an admin though to save the file.cstrub said:Found an easy solution, locate SQLPrompt.Format.CommandLine.exe on your computer (was in "D:\Program Files (x86)\Red Gate\SQL Prompt 9" on my computer).
using Visual Studio (File-->Open on the EXE) correct the Product Version from 10.14.22.11347+e4f26ea... to 10.14.22.11347). The issue is the Product Version for the file isn't valid for using with System.Version(string) method.
Hope this helps someone else who likes to be able to use SQL Prompt and SQL Compare
RSyester
3 ·
SQL Compare 15.3.11.27029 Error: Input string was not in a correct format
I tried going backwards to previous versions, without success.
I get this any time I click on differences, for any project. I submit, or cancel, then the program crashes.
I get this any time I click on differences, for any project. I submit, or cancel, then the program crashes.
jsreynolds1
1 ·
Re: SQL Search v3.6 crashes SSMS v18.10
A support ticket was opened to address the issue and I'm here to share some of the details for any users that might be experiencing the same behavior.
The issue has been resolved by uninstalling SQL Search and reinstalling the tool using the SQL Toolbelt Essentials installer.
They mentioned also having some issues with SQL Prompt. This was also uninstalled and reinstalled using the SQL Toolbelt Essentials installer..
If any users also experience this issue, I suggest doing the uninstall and reinstall using the latest SQL Toolbelt Essentials installer.
Kind regards,
Michael V
Product Support Engineer
The issue has been resolved by uninstalling SQL Search and reinstalling the tool using the SQL Toolbelt Essentials installer.
They mentioned also having some issues with SQL Prompt. This was also uninstalled and reinstalled using the SQL Toolbelt Essentials installer..
If any users also experience this issue, I suggest doing the uninstall and reinstall using the latest SQL Toolbelt Essentials installer.
Kind regards,
Michael V
Product Support Engineer
Michael_Valdez
1 ·
Re: SQL Compare 15.3.11.27029 Error: Input string was not in a correct format
Found an easy solution, locate SQLPrompt.Format.CommandLine.exe on your computer (was in "D:\Program Files (x86)\Red Gate\SQL Prompt 9" on my computer).
using Visual Studio (File-->Open on the EXE) correct the Product Version from 10.14.22.11347+e4f26ea... to 10.14.22.11347). The issue is the Product Version for the file isn't valid for using with System.Version(string) method.
Hope this helps someone else who likes to be able to use SQL Prompt and SQL Compare
using Visual Studio (File-->Open on the EXE) correct the Product Version from 10.14.22.11347+e4f26ea... to 10.14.22.11347). The issue is the Product Version for the file isn't valid for using with System.Version(string) method.
Hope this helps someone else who likes to be able to use SQL Prompt and SQL Compare
cstrub
7 ·
Cloud Storage Setting getting " The remote server returned an error (400) Bad Request
Hi
trying to setup cloud uploads to Azure Storage account but getting
" The remote server returned an error (400) Bad Request"
trying to setup cloud uploads to Azure Storage account but getting
" The remote server returned an error (400) Bad Request"
hpatel
1 ·
Re: Are there any examples or videos that show how to use Flyway with Databricks?
Disclaimer: I work at Databricks.
We now have a detailed blog published by the Databricks SQL SME group on how to use Flyway with Databricks. As @AlistairW commented above, it works exactly the same as any other SQL-type database.
Here is the URL to the blog post.
We now have a detailed blog published by the Databricks SQL SME group on how to use Flyway with Databricks. As @AlistairW commented above, it works exactly the same as any other SQL-type database.
Here is the URL to the blog post.
kbis
1 ·
Re: How to use TOML Configuration File
Hi kbis,
The plugin doesn't expose that functionality presently, as you can see from the cited page, this is just a preview. To get the full suite of functionality, you'll need to use a full flyway image in your pipeline.
You can see a variety of flavours and where to obtain them here
https://documentation.red-gate.com/flyway/flyway-cli-and-api/usage
The plugin doesn't expose that functionality presently, as you can see from the cited page, this is just a preview. To get the full suite of functionality, you'll need to use a full flyway image in your pipeline.
You can see a variety of flavours and where to obtain them here
https://documentation.red-gate.com/flyway/flyway-cli-and-api/usage
Peter_Laws
1 ·
SqlHistory.QueryVersions.DateSaved conversion to datetime
Does anyone know how to convert the DateSaved value stored in the SQLite database for SqlHistory to a datetime?
Restoring my saved pages became very slow after starting SSMS, which appeared to have happened because of the size of my SqlHistory database. After removing the 300MB SqlHistory.db file from my user directory, SSMS opens the saved pages quickly again. Also, I think the history itself is faster now.
That got me thinking that it would be a good idea to do more aggressive pruning of the history DB so I would not have to throw away all my history every once in a while. Opening the file in a SQLite browser is no problem, but I am stumped as to how the date is saved in the database.
I think the date is stored in SqlHistory.QueryVersions.DateSaved. I looked up a file which, before closing SSMS and SqlHistory, showed me a time of 21:11 and the date was 16-05-2024. The highest number shown for the date in the SQLite SqlHistory.db file was 133594612005169990. Alas, I can find no way to convert this number to the datetime ‘2024-05-16 21:11’. Using Google and Copilot, I could not convert it.
Does anyone know how to convert this? Preferably using SQLite syntax, but SQL Server or Python code would also be a big help!
Restoring my saved pages became very slow after starting SSMS, which appeared to have happened because of the size of my SqlHistory database. After removing the 300MB SqlHistory.db file from my user directory, SSMS opens the saved pages quickly again. Also, I think the history itself is faster now.
That got me thinking that it would be a good idea to do more aggressive pruning of the history DB so I would not have to throw away all my history every once in a while. Opening the file in a SQLite browser is no problem, but I am stumped as to how the date is saved in the database.
I think the date is stored in SqlHistory.QueryVersions.DateSaved. I looked up a file which, before closing SSMS and SqlHistory, showed me a time of 21:11 and the date was 16-05-2024. The highest number shown for the date in the SQLite SqlHistory.db file was 133594612005169990. Alas, I can find no way to convert this number to the datetime ‘2024-05-16 21:11’. Using Google and Copilot, I could not convert it.
Does anyone know how to convert this? Preferably using SQLite syntax, but SQL Server or Python code would also be a big help!
Remko1981
1 ·
Re: Is it possible to have SQL Prompt in Visual Studio Code
I would love to vote for this feature as well. This will be an incredible additional to the family if Redgate.
JOYR
1 ·
Re: Is it possible to have SQL Prompt in Visual Studio Code
UPVOTE - I'm increasingly using VSCode - please bring SQL Prompt to VSCode
David_Blake
1 ·
