Posts
Sort by recent activity
Will SCA support Visual Studio 2022
Hi,I think the question says it all... if the answer is yes, is there any time frame?Regards,Eric Lamontagne
SCA vs Flyway vs Redgate Deploy
Hi,I'm a bit confused about all these options. I've been using SCA for the last 8 months and lately I'm seeing many articles about flyway for database migration. I also see that there is Redgate de...
Creating a new baseline
Hi,I'm not certain how to name it, but what I want to do is create a new "version" of my database schema.We started at version 7.0 by creating a baseline.We then created a migration that we call 7....
Passing parameters to migration scripts
Hi,My understanding is that SCA uses sqlcmd to execute the migrations scripts.In these migrations scripts, there is a parameter (variable) $DatabaseName.Is there a way for me to have my own set of ...
Very slow Refresh on large database
Hi,I have a fairly large database/data warehouse that I use to performance tuning. (250 GB)
When I try to use SCA on this database, it takes a very long time (sometimes it fails).I pinned pointed t...
Floating actions drop down
Hi,I have a bunch of floating actions dropdown that are always there. They go away only when I close my Visual Studio environment. I often move from SSMS and VStudio 2019, they both have SQL Tools ...
Baseline compression enabled
Hi,Is it possible to enable table compression when creating the base line?My source database as compression, but the baseline does NOT include any compression, am I missing some settings?Regards,
E...
Powershell 7
Hi,Can you tell me if Powershell 7 should be supported or not?I tried running the Invoke-DatabaseBuild cmdlet and I get this error in PS 7, but not in PS 5:Invoke-DatabaseBuild: An unhandled error ...
Change Script check if exists
Hello,When generating a change script, there is no safeguard to check if the affected object already exists or not.Is there an option I can set so it does a check before executing the change?I unde...
Deploying Database migration script to an external database
Hi,We are developing and selling a solution using SQL Server database.We an home made "installer" taking migration scripts and upgrading existing client databases when they do an upgrade.We would l...