Activity overview
Latest activity by Elizabeth_Close_M1st
Thank you Sergio, we have created a Git repository on a network share and are working through the Octopus process. I appreciate your advice.
E / comments
Thank you Sergio, we have created a Git repository on a network share and are working through the Octopus process. I appreciate your advice.
E
How to get Custom Filters over to Octopus for deployment
We have several in-house databases that contain references to Linked Servers - which won't deploy within a transaction. I created filters so those objects are in a separate update.sql file without ...
Hi Eddie - You are correct, It's in SQL Prompt. I deleted all linked servers from my local instance and wanted to find out which ones I really needed but Invalid Objects didn't see the linked server(s) being missing
Thanks
Elizabeth / comments
Hi Eddie - You are correct, It's in SQL Prompt. I deleted all linked servers from my local instance and wanted to find out which ones I really needed but Invalid Objects didn't see the linked serv...
Invalid Objects or future enhancement
I tried to use InvalidObjects finder to list DB objects that use a LinkedServer that either "doesn't exist" or "doesn't validate" ... is there another way (besides drop/recreate) that will find these?
Errors occurred whilst parsing file C:\Users\closee\AppData\Local\Red Gate\SQL Source Control 5\WorkingBases\sxap3hvq.cic\Databases\OnlineBanking\_Initialization\02_CreateNewOnlineBankingDatabase.sql
'' at line 107, column 69
'' at line 110, column 68
*****
This is line 107: ALTER DATABASE [OnlineBanking] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF, DIRECTORY_NAME = N'OnlineBankingDocStore' )
This is line 110: ALTER DATABASE [OnlineBanking] SET TARGET_RECOVERY_TIME = 0 SECONDS / comments
Errors occurred whilst parsing file C:\Users\closee\AppData\Local\Red Gate\SQL Source Control 5\WorkingBases\sxap3hvq.cic\Databases\OnlineBanking\_Initialization\02_CreateNewOnlineBankingDatabase.s...
SCC folder structure
I added a folder(CreateDB) and scripts inside the "Database" folder... using GIT outside SCC I committed the folder and scripts to master. Now I get a parse error every time I try to link or "ge...
I'm not totally sure what you're needing, but at the top of the SQLDataCompare results pane there are tabs that let you view All Rows, Only in Left, Only in Right, and In both but different
Also if you click any of the headers in the results pane the values will sort based on that column
HTH! / comments
I'm not totally sure what you're needing, but at the top of the SQLDataCompare results pane there are tabs that let you view All Rows, Only in Left, Only in Right, and In both but different
Also if...
I found that Migration script works for including DML steps / comments
I found that Migration script works for including DML steps