Tag: SQL Server
Couchbase Catalogs for the SQL Server DBA
In this post, we introduce System Catalogs in Couchbase and walk through a specific use case compared to SQL Server. If you’re like me, after 20 years of working with SQL Server, you tend to pick up on things that...
How to Denormalize Imported Documents from RDBMS Tables Using N1QL
Data migration is full of challenges. While migrating from a relational database (RDBMS) like SQL Server or Oracle, your main challenge comes at the time of denormalizing migrated documents as per the target data models. With the introduction of scopes...
SQL and NoSQL comparison: ASP.NET application
This SQL and NoSQL comparison is the next step after converting your SQL Server database to Couchbase. In the previous post, I copied AdventureWorks from SQL Server to Couchbase. In this post, I’m going to show an ASP.NET Core application...
SQL to NoSQL: Automated Migration
SQL to NoSQL migration seems like a contradiction, but thanks to advances and innovations in Couchbase Server’s NoSQL database, it’s becoming easier. In this post, I’ll introduce you to a tool called SqlServerToCouchbase, an open-source attempt at an automated tool...
Extend Couchbase Analytics with SQL Server using CData
Extend Couchbase Analytics with SQL Server using CData. This article will guide you through the steps needed to setup the connection from Couchbase Analytics to SQL Server using the CData ODBC driver for Couchbase. More details regarding this driver can...
Proof of Concept: Making a case to move from relational
Proof of concept may be just what you need to start when you’re evaluating Couchbase. We’ve been blogging a lot about the technical side of moving from a relational database like Oracle or SQL Server to Couchbase. Here are some...
JSON Modeling for RDBMS Users (video)
JSON modeling was covered in a previous blog post which was, in turn, based on a CSV import blog post that came before that. While writing the post on JSON modeling, it occurred to me that it might be useful...
JSON Data Modeling for RDBMS Users
JSON data modeling is a vital part of using a document database like Couchbase. Beyond understanding the basics of JSON, there are two key approaches to modeling relationships between data that will be covered in this blog post. The examples...
CSV tooling for migrating to Couchbase from Relational
CSV (Comma-seperated values) is a file format that can be exported from a relational database (like Oracle or SQL Server). It can then be imported into Couchbase Server with the cbimport utility. Note: cbimport comes with Couchbase Enterprise Edition. For...
SQL Server and Couchbase side-by-side (video)
SQL Server is compared (and contrasted) with Couchbase Server in this video. If you are averse to video, you can check out the corresponding blog post series I wrote a few months ago that covers the same material: Part 1...
SQL to JSON Data Modeling with Hackolade
SQL to JSON data modeling is something I touched on in the first part of my “Moving from SQL Server to Couchbase” series. Since that blog post, some new tooling has come to my attention from Hackolade, which has recently...
Moving from SQL Server to Couchbase Part 3: App Migration
Moving from SQL Server to Couchbase Part 3: App Migration In this series of blog posts, I’m going to lay out the considerations when moving to a document database when you have a relational background. Specifically, Microsoft SQL Server as...