Posts
Sort by recent activity
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...