If I am not wrong, all the VIP packet (including Frame Buffer) is OpenCore+. So you can try it programming the FPGA with .sof file. Anyway, if you need it to work uninterruptedly you would need .pof file.. and to obtain it you need license.
You need a SDRAM controller IP surely. A question: why do you want to use CVI and transform video in Avalon Streaming format? In my opinion, if you can't use Altera IP from VIP suite it's useless.
I would try to store the video from OV7670 directly to the SDRAM.
But maybe someone could correct me.