Activity overview
Latest activity by leehbi
I'll raise a support ticket with some logging info. / comments
I'll raise a support ticket with some logging info.
Metadata is data in tables that describe schema for use in packages. Not extended properties - just plain old data. It's actually used by BIML to build packages i.e. the meta data describes sources/destinations. We're using Jenkins to control the build We check in the scripts from SQL Compare/Data Compare and jenkins then uses these scripts when building/deploying. Not a problem deploying the data it's just that some of the data shouldn't be deployed. I think the issue is that the powershell scripts aren't as powerful as SQL Data Compare. Is there an easy way for me to exclude specific columns from a table from being deployed? Lee / comments
Metadata is data in tables that describe schema for use in packages. Not extended properties - just plain old data. It's actually used by BIML to build packages i.e. the meta data describes sourc...
Temporal table support
Hi,We have a temporal table in our DB. If we amend the schema the powershell build automation scripts fail with 'schema in in correct state'.The only way we can overcome this is to convert the tab...
Limitations of DLM/SQL Data Compare
Hi,We use SQL Data Compare as part of our CD process with the DLM scripts to deploy changes from dev to test to prod. The workload is a data warehouse. We have data for things like ETL audit/las...
Thanks, this sorted it for me. / comments
Thanks, this sorted it for me.