You can use python to script the resourcing of all your map documents.
Updating and fixing data sources with arcpy.mapping—Help | ArcGIS for Desktop
A simple example would be...
import arcpy
mxd = arcpy.mapping.MapDocument(r"C:\ResourceMe.mxd")
for lyr in arcpy.mapping.ListLayers(mxd):
if lyr.isRasterLayer:
print lyr.dataSource
wsp = lyr.workspacePath
ds = lyr.datasetName
lyr.replaceDataSource(r"C:\Users\userprofile\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DirectConnect.sde", "SDE_WORKSPACE", ds, False)
lyr.name = ds
else:
mxd.findAndReplaceWorkspacePaths(r"C:\Users\userprofile\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\AppSvr10.sde",r"C:\Users\userprofile\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DirectConnect.sde", False)
mxd.saveACopy(r"C:\ResourceMe1.mxd")
del mxd
print complete