git command line would be the way to go - I have limited experience so can't really give you good details but have a look at https://docs.gitlab.com/ee/gitlab-basics/start-using-git.html

from a brief reading...

lots of ways to skin a cat 🙂

thanks guys - I forgot about the number of VLF - one would expect that these days where this is well known fact that any DBA has already...

And on a different note - there is no need for that extra unique index - if the hash is done correctly and it is based on those columns then...

Then go back...

• This reply was modified 6 years, 4 months ago by frederico_fonseca.

if you are following Data Vault design then you have too many columns on that hub. most of the columns there look like attributes of your business key and are...

• This reply was modified 6 years, 4 months ago by frederico_fonseca.

thanks guys - I forgot about the number of VLF - one would expect that these days where this is well known fact that any DBA has already set that...

Can you please state what is the size of the log file - I did ask for it to be supplied separately - if your datafiles are 300GB and your...

I think this may depend on the company and even on the country.

I've been contracting for over 30 years - first 10 in Portugal - not quite that good (bad...

you can install OpenXML SDK and use that to create Excel Files without the need for Office to be installed.

But yes it does require coding in C# to do...

• This reply was modified 6 years, 4 months ago by frederico_fonseca.
• This reply was modified 6 years, 4 months ago by frederico_fonseca.

try this from Brad Shulz http://bradsruminations.blogspot.com/2011/01/so-you-want-to-read-csv-files-huh.html

it may do what you need

• This reply was modified 6 years, 4 months ago by frederico_fonseca.

you can use the one you desire.

and you need to change "-t7z" to be...

this is what I do in some (old) packages

note that the "add to zip " does not delete the files - on newer versions you would need to add "-sdel"...

you automate it in a similar way to winzip (assuming you were using the command line interface and not the c# dll)

I'll dig some of my examples and post here

Thanks Frederico. So you agree that CDC is similar to SQL Server transactional replication? Since setting up SQL Server replication also requires all tables to have primary key. You...

• This reply was modified 6 years, 4 months ago by frederico_fonseca.