Checklist to Consider Before Migrating from SQL Server to NoSQL
Here’s a checklist of items to consider before migrating to a NoSQL db from SQL Server. If you come from SQL Server land, you may be used to these features and facilities. So before shifting over to a different world, consider if the db you’re jumping into (MongoDB, CouchDB, etc.) meets your needs by analyzing these items. Keep in mind that some features may not exist in NoSQL, not because of immaturity, but because it may not apply to the nature of a NoSQL database.
Handle Load
Compare against SQL Server:
Reading
Writing
Resource Monitoring
CPU Usage
Memory Use
Disk use
Transactions
Are there software design patterns to rollback
Locking
Reading
Programming
Syntax
SELECT / UPDATE / DELETE / INSERT / JOINS
Reusable Code Modules
Compiled Stored procs
Functions
Custom Data Types
Dynamic Management Views
Indexing
Clustered
Non-Clustered
Toolset / Resources
IDE
Administration
Profiler
Excution Planner
Community
Books
Administration
Complexity
Backing up
Full
Differentials
Transaction Log
Recovery
Replication / Clustering
Snapshots
Security
C# Integration
Facilities
Full Text Search
Snapshots
Categories