Viewing 15 posts - 1 through 15 (of 275 total)
Data Factory is a standalone tool for moving data from source to destination that can also transform data along the way (it does a lot more than that!)
The same Data...
June 8, 2022 at 9:23 am
I'll have a go at answering but I'm sure others will have more experience of this than me!
Synapse is integrated with Data Factory which is kind of like SSIS in...
June 8, 2022 at 8:44 am
Do you get any error messages? It's difficult to help without more information
January 7, 2022 at 9:23 am
The following shows what types of service can be moved between subscription and resource groups in Azure:
https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/move-support-resources
Managed instance can't be moved and neither can the databases directly. Think you...
December 9, 2021 at 11:16 am
It doesn't load balance, it just directs the connection to the appropriate server.
Is the secondary set to allow connections?
December 8, 2021 at 2:39 pm
You can disable the replication of DDL changes via the GUI, right-click on publication, click properties, select subscriber options and disable 'Replicate schema changes'
You can script out your replication, right-click...
December 8, 2021 at 12:22 pm
Sorry it's been such a pain to get it set up, it's normally not as bad as that!
Can only suggest adding the following to the snapshot job step to maybe...
December 7, 2021 at 12:03 pm
Is the snapshot agent account :
Is the merge agent account :
December 2, 2021 at 9:58 am
I've not used peer to peer replication, I think it would do what you want (active-active servers) but it's an Enterprise Edition feature.
Merge replication would also do it. Data changes...
December 1, 2021 at 6:04 pm
Data Factory isn't really real-time or continuous, it runs on a schedule to transfer data from source to destination.
Basically:
December 1, 2021 at 5:43 pm
Query timeout is set by the application so maybe you could adjust that to prevent errors until you find the culprit.
Run profiler or use extended events to capture the queries...
December 1, 2021 at 5:26 pm
Data Factory uses bulk copy really and it's all in Azure if using Managed Instances so is quite fast. However, you can't truncate a table if you have CDC enabled...
November 24, 2021 at 12:23 pm
Think those are the only realistic options. We use all 3 of those for various reasons but we also have some CDC and Data Factory in place to keep two...
November 24, 2021 at 10:46 am
What are you testing here? A nice, safe, planned failover from A to B to check the DR site works? If that is the case then I would switch to...
November 24, 2021 at 10:36 am
I can't really answer how much they use but replication uses SQL jobs that call executables. So it might be possible to measure what resources they use in the OS...
November 18, 2021 at 2:14 pm
Viewing 15 posts - 1 through 15 (of 275 total)