Home

Migrate upgraded ADFS farm from WID to SQL

%3CLINGO-SUB%20id%3D%22lingo-sub-1098527%22%20slang%3D%22en-US%22%3EMigrate%20upgraded%20ADFS%20farm%20from%20WID%20to%20SQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1098527%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20few%20ADFS%20farms%20that%20have%20been%20upgraded%2Fmigrated%20from%20ADFS%20v3%20to%20ADFS%20v4%20in%20the%20past.%20We%20now%20want%20to%20migrated%20the%20WID%20database%20to%20SQL%20Always-On.%20There%20are%20numerous%20articles%20describing%20the%20migration%20from%20WID%20to%20SQL%2C%20but%20they%20all%20only%20mention%20AdfsConfiguration.mdf%2C%20but%20in%20an%20upgraded%20farm%20you%20also%20have%20a%20AdfsConfigurationV3.mdf%20(and%20its%20respective%20ldf).%20Can%20we%20ignore%20the%20V3%20files%20or%20do%20we%20need%20to%20migrate%20them%20to%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3EEnrico%20Klein%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1098527%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eactive%20directory%20federation%20services%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWindows%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
EnricoKlein
Occasional Visitor

Hi,

 

We have a few ADFS farms that have been upgraded/migrated from ADFS v3 to ADFS v4 in the past. We now want to migrated the WID database to SQL Always-On. There are numerous articles describing the migration from WID to SQL, but they all only mention AdfsConfiguration.mdf, but in an upgraded farm you also have a AdfsConfigurationV3.mdf (and its respective ldf). Can we ignore the V3 files or do we need to migrate them to?

 

Please advise!

 

Kind regards,

Enrico Klein

Related Conversations
Windows 10 VPN and SQL with Meraki VPN
redtechguy in Windows 10 on
4 Replies
Windows 10 VPN and SQL with Meraki VPN
redtechguy in SQL Server on
0 Replies
HOW can i combine 3 columns as sub columns
Varghese97 in SharePoint Developer on
0 Replies
Excel with Sql Server connection
petyac81 in Office 365 on
0 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies