Altera Ethernet Example for BeMicro A9

I've seen an app note that details how to use a boot loader in on-chip ram to copy data from serial flash like your board uses to sdram and then run the NIOS software from there. You should be able to adapt that example to your needs. If all else fails, you could write some code to issue a read command from the serial flash to sdram and then branch to it manually.