The DDL scripts for CDM have variables like “@cdmDatabaseSchema”. If I try to set the variable and then run the script using something like
DECLARE @cdmDatabaseSchemavarchar(64) = 'my_schema';
I get errors when I try to run the script in MS Sql Server Manager.
The post at the link below seems to suggest that to use the variable the entire query should be wrapped in a variable.
Is there a way to set this variable and run the script or do I basically just need to do a global search and replace?
(I did a search on “@cdmDatabaseSchema” on this forum and didn’t get any results so appologies in advance if this has already been asked and answered. )