Schema Compare in 2023.1

Avatar
Clint Mayer
Created

Is anyone else not seeing the Schema Compare option in the new release? I've tried right clicking the project folder and the sqlproj file. Neither have the option for me. I also switched to the new UI and rebooted.

Votes

0

Share

3 comments
Avatar
Alexandra Guk
Created

Hi Clint Mayer! 

Do you have Visual Studio installed?  Rider’s Schema Compare implementation is based on SQL Server Data Tools and therefore requires you to have Microsoft Visual Studio (version 2017 or newer) installed on your computer.

0
Avatar
Clint Mayer
Created

Yes, I have it installed with SQL Server Data Tools. Schema Compare for SSDT is one of the few things I still open Visual Studio for 😅.

Here is a subset of what Visual Studio about shows me:

Microsoft Visual Studio Professional 2022
Version 17.5.3
VisualStudio.17.Release/17.5.3+33516.290
Microsoft .NET Framework
Version 4.8.04084

Installed Version: Professional

ASP.NET and Web Tools   17.5.318.41597
ASP.NET and Web Tools

C# Tools   4.5.0-6.23128.14+651d32d8017cfcc60fcbd67383601fa9a3deb145
C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

SQL Server Data Tools   17.2.40119.0
Microsoft SQL Server Data Tools

Just to be sure, should I see it when right-clicking the sqlproj file?

0
Avatar
Clint Mayer
Created

So I've discovered that having a solution file is required for this to work. I found Schema Compare using the Action Search (Ctrl+T) but it wouldn't let me choose my project for target or source. When I added a solution file to the project, I was able to find Schema Compare within the right click menu.

We have always just operated our SSDT as a sqlproj only.

1

Please sign in to leave a comment.