Etiqueta: SQL Server
Catálogos do Couchbase para o DBA do SQL Server
Nesta postagem, apresentamos os catálogos de sistema no Couchbase e analisamos um caso de uso específico em comparação com o SQL Server. Se você for como eu, depois de 20 anos de trabalho com o SQL Server, tende a perceber coisas que...
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...
Comparação entre SQL e NoSQL: Aplicativo ASP.NET
Essa comparação entre SQL e NoSQL é a próxima etapa após a conversão do seu banco de dados do SQL Server para o Couchbase. Na postagem anterior, copiei o AdventureWorks do SQL Server para o Couchbase. Nesta postagem, vou mostrar um aplicativo ASP.NET Core...
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...