I would like to ship logs to a reporting database and would like to avoid restoring a database backup. Is this or will it be possible? - thx
It might be possible on a Manged SQL server, but not on the shared servers. If you think you might be interested in a Managed SQL Server, drop an email to support@ and they can check in to the viability of log shipping for you.
Thank you - do you know how people are architecting a separate near realtime reporting database with NopCommerce in the shared server environment?
A separate reporting database, no. Maybe if someone else is doing what you're trying to do they can chime in here with some advice. Is there a reason you can't use SQL Reporting Service on the primary NopCommerce database? Because that is included in every plan, and it would be available for a shared SQL database.
I like the bundled SQL Reporting Services, but generally don't like to mix ad-hoc or potentially large/batch reporting operations with transactional systems. It's a pretty standard strategy to separate near real-time reporting from transactions. Just looking at options with Everleap right now, and may very well use the primary DB for first phase. - thanks for your help.
