Tag: SQL Server

Couchbase Catalogs for the SQL Server DBA

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

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...

December 1, 2021
SQL and NoSQL comparison: ASP.NET application

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...

May 27, 2021
SQL to NoSQL: Automated Migration

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...

March 2, 2021
Extend Couchbase Analytics with SQL Server using CData

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: 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...

January 29, 2018
JSON Modeling for RDBMS Users (video)

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...

January 26, 2018
JSON Data Modeling for RDBMS Users

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...

January 25, 2018
CSV tooling for migrating to Couchbase from Relational

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...

January 18, 2018
SQL Server and Couchbase side-by-side (video)

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...

July 17, 2017
SQL to JSON Data Modeling with Hackolade

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...

April 13, 2017
Moving from SQL Server to Couchbase Part 3: App Migration

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...

March 7, 2017