Best Of

Re: SQL Compare 15.3.11.27029 Error: Input string was not in a correct format

I think I found the culprit. Short version: uninstall the latest release of SQL Prompt and get the June 2024 version.

This was my trail of tears troubleshooting:

Uninstall all

Reboot workstation

Install SQL Compare

Launch SQL Compare, did comparison - WORKS

Install SQL Backup (launched SQL Backup, works fine)

Launch SQL Compare, did comparison - WORKS

Install SQL Prompt (launched SSMS, SQL Prompt works fine)

Launch SQL Compare, did comparison - FAILED, crash do desktop

Close SSMS

Launch SQL Compare, did comparison - FAILED, crash do desktop

Uninstall SQL Prompt

Launch SQL Compare, did comparison - WORKS

Install SQL Data Compare (launched, SQL Data Compare works fine)

Launch SQL Compare, did comparison - WORKS

Install SQL Source Control (launched SSMS, SQL Source Control works fine)

Launch SQL Compare, did comparison - WORKS

Install SQL Dependency Tracker 3.3 (launched SSMS, did dependency comparison, works fine)

Launch SQL Compare, did comparison - WORKS

Install SSMS Integration Pack 3.2 (launched SSMS, did comparison, works fine)

Launch SQL Compare, did comparison - WORKS

Install SQL Search 3.6 (launched SSMS, did search, works fine)

Launch SQL Compare, did comparison - WORKS

Install SQL Doc 4.2 (launched and documented a database, works fine)

Launch SQL Compare, did comparison - WORKS

At this point, I have installed everything I use from SQL Toolbelt.

The two things I use the most are SQL Prompt and SQL Compare.

I try installing SQL Prompt one more time to see if it has to do with the install order.

Try running SQL Compare - compared, clicked FAIL crash to desktop.

Uninstalled SQL Prompt 10.14.22.11347.

Downloaded older stable version SQL Prompt 10.14.21.9884, installed.

SQL Compare - WORKS FINE.

Moral of the story, something is wrong with SQL Prompt build 10.14.22.11347 and SQL Compare.

jsreynolds1

1 ·

Re: Cannot drop the database 'SqlCloneTemp_cekvf232' because it is being used for replication

Hi ab12, thank you for your forum post.

To reply to this comment:

I'm not sure neither what is this database created automatically.

SQL Clone when creating a SQL Clone Image from a backup file and /or applying data masking to an image, the process creates a temporary database to restore the backup file into.

I suspect the issue reported here:

2024-09-27 16:32:16.250 +02:00 [Warning] Failed to detach database "SqlCloneTemp_cekvf232", falling back to hard detach

Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot drop the database 'SqlCloneTemp_cekvf232' because it is being used for replication.

The source database is configured to use SQL Server Replication features. So when the process completes, SQL Clone cleans up to remove the temporary database and cannot due to the SQL Server Replication configured.

Sadly SQL Clone was never tested on databases using SQL Server Replication technology. I suspect that you will need to manually drop the temporary database created.

Many Thanks
Eddie

Eddie D

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

cstrub

3 ·

Re: Are there any examples or videos that show how to use Flyway with Databricks?

kbis said:

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.

@kbis ty! This is what I was looking for.

dmeyers

1 ·

Re: Are there any examples or videos that show how to use Flyway with Databricks?

Hi @kbis, I'm Claire, Product Marketing Manager for Flyway. Thank you very much for sharing your blog post on using Flyway with Databricks - that's great to see! We would be very happy to share your blog post in an upcoming newsletter with Flyway users if that would be of interest. If you'd like to discuss, I'd be very happy to catch up over email (claire.matthews@red-gate.com).

ClaireMatthews

1 ·

Re: Are there any examples or videos that show how to use Flyway with Databricks?

I don't believe that Redgate has produced any - our experience with Databricks has been that it is exactly the same as any other SQL-type database using Flyway migrations so beyond difference in the connection URL, everything else is the same.
https://documentation.red-gate.com/fd/databricks-243272862.html
Are there any specific things you are struggling with ?

AlistairW

1 ·

Re: SqlHistory.QueryVersions.DateSaved conversion to datetime

It looks like SQLPrompt is using LDAP/AD/NT timestamp format which is the number of 100ms ticks since 1/1/1601. Based on this I came up with this SQL which is working for me so far (more testing needed):

SELECT

datetime('1601-01-01', (qv.DateSaved / 10000000)||' seconds')

,*

FROM

QueryVersions qv

SQLHatGuy

1 ·

Re: recent install, can't access settings

Thanks @end-user, first I believed it was some kind of error or bug, but after reading your comment I got to know the whole scenario.Thanks.

aliajmal

1 ·