When you say you are trying to 'load all the data', do you mean ArcFM Configuration, such as Model names and Autoupdaters? In the first sentence you state that the 'data' has already been migrated, so I just wanted to clarify.
If the schema on the old PGDB and new SQL Server database match exactly, an ArcFM XML Export from the old PGDB followed by an ArcFM XML Import on the new SQL DB should do the trick. If the schema names changed, a modification to the ArcFM XML export will need to be performed prior to importing. I can help you with this.
Let me know if this helped or if you still have questions.
We took care of this a couple of weeks ago by doing a copy / paste on for the actual data and an ArcFM export / import for the all the model name, etc... settings.