Do you see the issue in this though? Your biggest issue is keeping the MSSQL server in sync with the MySQL server. vBulletin does not work on MSSQL. As far as stored procedures, I would recommend against this. You have the potential to really mess up the database. It's better to pass the data to vb and then have vb validate the data and do the necessary sql queries. I think it's a bit more involved than a simple INSERT query.
I don't know what you mean by business objects.
|