SSDT for VS2019 is the best tool available for database projects in a Windows/.NET ecosystem, but the installation experience and occasional designer instability prevent it from being great. Use it, but keep SSMS installed as a backup for direct server operations.
After install, go to Tools → Options → SQL Server Tools → General and set "Enable advanced deployment options" to True . This unlocks SqlPackage.exe parameters like /p:IgnoreColumnOrder=true . install ssdt for visual studio 2019