1

My requirement is to maintain two database in SQL Server 2014 Management Studio (one for transaction and another for reporting) for single application developed in EF 7 and MVC 6.

My question is

  1. what are the technologies I can implement for my requirement?
  2. How to Implement and maintain two database?

I did some R&D regarding the requirement here but I cannot find the actual solution. Solution I find from R&D is Mirroring, synchronisation and CDT. I am not been able to figure out which technology to use for data replication.

I want to feed data in reporting db at the time of transaction in transaction db and I may be allowed for updating the reporting db.

halfer
  • 19,824
  • 17
  • 99
  • 186
Iswar
  • 2,211
  • 11
  • 40
  • 65
  • "Teach me using databases" - too broad. "Teach me about data marts, and ETL" - too broad. "Tell me what technologies to use" - off topic. – TomTom Mar 29 '16 at 07:46
  • Agree with @TomTom, this is rather too broad for this platform. I have voted to put on hold. – halfer Jun 23 '18 at 11:08

1 Answers1

0

Basically SQL Server 2014 is the first in-memory database on SQL Server data platform. This means, the transactional (OLTP) and reporting (OLAP) capabilities are merged and covered by SQL Server 2014. You can check how to create in-memory database on SQL Server 2014. Actually I'm not sure how successful is this approach but SAP HANA is being marketed with this saying. The column-store indexing and compression ratios with decreasing prizes of memory brought in-memory databases enhancements with Sybase, SQL Server, Hana and now Oracle

Eralper
  • 6,461
  • 2
  • 21
  • 27