Posts
Sort by recent activity
Schema-Model behavior when using ScriptInMigrations option
According to this Redgate documentation, using the ScriptInMigrations option in the ProgrammableObjectHandling setting has this effect:This effectively disables the programmable object feature and...
PowerShell error "running scripts is disabled on this system"
I'm brand new to SQL Change Automation and am to the point where I'm trying to run some of the PowerShell scripts on my machine. I installed SQL Change Automation PowerShell 4.3.20267.22294 via the...
How to customize migration scripts in state-based approach
I've been reading and watching many of the docs/videos about SCA as we try to use SCA for the first time. But it has been tough. The latest question is about using custom migration scripts with the...
ScriptInMigrations vs UseRepeatableScriptsForAllObjects
Can someone please explain the difference between ScriptInMigrations and UseRepeatableScriptsForAllObjects in the ProgrammableObjectHandling setting? I've already read the definition in the Redgate...
Bug: Fillfactor on Table Types
My Source Control crashed a few days ago and I had to reinstall it. After reinstalling (v3.6.6.178), Source Control now shows a Fillfactor setting on my user-defined Table Types, which it did not d...
SQL Test is over a year behind tSQLt
tSQLt is now on version 1.0.4941.23369 (released July 2013), but SQL Test v1.0.15.1 is still on tSQLt v1.0.4504.21220 (released May 2012). That is 2-3 versions behind. There are features tSQLt rele...
Bug: Deploy script does not include extended properites
I am changing the definition of 3 indexes. They all have extended properties for MS_Description. When SQL Compare (10.3.8.406) builds the deployment script, it drops, then creates the indexes. That...
Lost migration script in SSMS
I recently created a migration script to cover some changes to a table and sprocs. When I committed the changes yesterday, the file disappeared from the "Migrations" tab of SQL Source Control. I ha...
Trouble testing an expected sproc failure
I am new to SQL Test and I'm trying to test that a sproc will fail when expected and am having some problems. I am curious if anyone has a work-around or can tell me what I've done wrong.
From wha...
How to test a trigger?
TableA has Trigger1 that inserts data into TableB. I'd like to test that the trigger works correctly. Can I do that with SQL Test? I haven't been able to find a way yet. Does FakeTable handle trigg...