I want to take Montreal Impact delete their club history and such and replace them with Orlando City so that Orlando plays the 2014 season and Montreal Impact joins the MLS in 2015 as the expansion team but not sure what i have to edit in the database...
I tried it out and figured out how to do it.
Switch competitions between Orlando and Toronto. Do that by going to Toronto's team page, then to the comp tab, then make these changes:
Division: Major league Soccer >>> American Third Division - Eastern Conference
Last Division: Major League Soccer >>> Blank or American Third Division - Eastern Conference
Next Division: Blank >>> Major League Soccer
For Orlando City:
Division: American Third Division - Eastern Conference >>> Major League Soccer
Last Division: American Third Division >>> Doesn't matter. You can change to MLS, blank or keep at American Third Div
Next Division: Major League Soccer >>> Blank
After you do that, go to the MLS competition page. Go to the Registered Teams tab. It is the 5th one down on the left. You will see 2 teams listed there: NYCFC and Orlando City. Don't delete Orlando city, but simply switch them with Toronto.
That is all you need to do. You can do all of this without toughing the nation rules or advance rules.