So, will this work from moving data from SQL 2012 to SQL 2017? Would this need to be setup as a SQL job?

im not trying to be a pain, but...

Thank you for the response. So basically I can create a .NET application to provide additional functionality, but reading headers and splitting as you’ve suggested . Then I can repeat...

Correct. If they went' in and added new schema such as the one described above, would SSiS be able to detect that? Or, if they changed a stored procedure etc....

Hmm, I suppose that would be a situation where an email should be sent out from SSIS. However, if there's been a new schema added, is that something that SSIS...

Thank you. So for instance, if I have an SSIS package that is looking at Table1 which has 5 columns in it. Then, when the package runs via scheduling agent,...

The databases have some frequent schema changes such as adding a new schema, or modifying a stored procedure, function or trigger. I forgot to mention the databases also use custom...

Sue, thank you. Also, are we able to just utilize Microsoft Windows Server as the provider? For instance, utilize Storage Spaces Direct?

-Trent

Thanks Sue.

The database is a call logging database that's used for medical translation services. For instance, when a hospital needs translation services, they'd call a number and get connected to a...

That you for your response. I'm not too sure what ad-hoc workloads are. I believe this database is using stored procedures. This database is not utilizing EF. I'm trying to...

Thanks for the heads-up on that. Once we get it squared away, I'll be sure to keep an eye out for this.

Mike, thank you for your response. I'm fairly comfortable setting up AGs. However, I've always been able to do this outside of business hours, or had permission to take a...

Theo, I greatly appreciate your help. I was figuring of setting things up the way you described in your recent response. I was working on a Visio diagram of the...

I agree with you Theo. The customer is a DoD sub-contractor and therefore extreme caution must be used when dealing with that data, hence zero data loss. I know the...

I'm currently using Azure Data Sync and transactional replication. It works great with the AdventrueWorks DB that I'm doing testing with. However, now the customer is wanting HA and, I've...