Kory KramerMichael Volz
I found a solution. One of the ESRI Tech Support article it has the solution. I have tested it and it replaced my data sources. Because of my projects has only one data source for each, it worked for me. Still we need to have the multiple data source replace capability for the situation. ESRI ArcGIS Pro development team should put this a bit of higher priority because it actually is a very important tool. below my code-
import arcpy as py
aprx = py.mp.ArcGISProject(r'project_location')
find_dict = {'connection_info': {'instance': 'sde:sqlserver:server_instance',
'server': 'server_name'}}
replace_dict = {'connection_info': {'instance': 'sde:sqlserver:server_instance',
'server': 'server_name', 'authentication_mode': 'OSA'}}
try:
aprx.updateConnectionProperties(find_dict, replace_dict)
py.AddMessage("Data Source Updated")
except NameError:
py.AddMessage(' does not replaced SQL data Source!!!')
aprx.save()
Hopefully this will help others.