Microsoft SQL Server vs Vitess

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Microsoft SQL Server
Microsoft SQL Server

3.7K
2.6K
+ 1
525
Vitess
Vitess

6
7
+ 1
0
Add tool

Microsoft SQL Server vs Vitess: What are the differences?

What is Microsoft SQL Server? A relational database management system developed by Microsoft. Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

What is Vitess? It is a database clustering system for horizontal scaling of MySQL. It is a database solution for deploying, scaling and managing large clusters of MySQL instances. It’s architected to run as effectively in a public or private cloud architecture as it does on dedicated hardware. It combines and extends many important MySQL features with the scalability of a NoSQL database.

Microsoft SQL Server and Vitess can be categorized as "Databases" tools.

- No public GitHub repository available -
- No public GitHub repository available -

What is Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

What is Vitess?

It is a database solution for deploying, scaling and managing large clusters of MySQL instances. It’s architected to run as effectively in a public or private cloud architecture as it does on dedicated hardware. It combines and extends many important MySQL features with the scalability of a NoSQL database.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Microsoft SQL Server?
Why do developers choose Vitess?
    Be the first to leave a pro

    Sign up to add, upvote and see more prosMake informed product decisions

      Be the first to leave a con
      What companies use Microsoft SQL Server?
      What companies use Vitess?

      Sign up to get full access to all the companiesMake informed product decisions

      What tools integrate with Microsoft SQL Server?
      What tools integrate with Vitess?

      Sign up to get full access to all the tool integrationsMake informed product decisions

      What are some alternatives to Microsoft SQL Server and Vitess?
      Oracle
      Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
      Apache Aurora
      Apache Aurora is a service scheduler that runs on top of Mesos, enabling you to run long-running services that take advantage of Mesos' scalability, fault-tolerance, and resource isolation.
      PostgreSQL
      PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
      Microsoft Access
      It is an easy-to-use tool for creating business applications, from templates or from scratch. With its rich and intuitive design tools, it can help you create appealing and highly functional applications in a minimal amount of time.
      MySQL
      The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
      See all alternatives
      Decisions about Microsoft SQL Server and Vitess
      StackShare Editors
      StackShare Editors
      Vitess
      Vitess
      MySQL
      MySQL

      They're critical to the business data and operated by an ecosystem of tools. But once the tools have been used, it was important to verify that the data remains as expected at all times. Even with the best efforts to prevent errors, inconsistencies are bound to creep at any stage. In order to test the code in a comprehensive manner, Slack developed a structure known as a consistency check framework.

      This is a responsive and personalized framework that can meaningfully analyze and report on your data with a number of proactive and reactive benefits. This framework is important because it can help with repair and recovery from an outage or bug, it can help ensure effective data migration through scripts that test the code post-migration, and find bugs throughout the database. This framework helped prevent duplication and identifies the canonical code in each case, running as reusable code.

      The framework was created by creating generic versions of the scanning and reporting code and an interface for the checking code. The checks could be run from the command line and either a single team could be scanned or the whole system. The process was improved over time to further customize the checks and make them more specific. In order to make this framework accessible to everyone, a GUI was added and connected to the internal administrative system. The framework was also modified to include code that can fix certain problems, while others are left for manual intervention. For Slack, such a tool proved extremely beneficial in ensuring data integrity both internally and externally.

      See more
      Amazon ElastiCache
      Amazon ElastiCache
      Amazon Elasticsearch Service
      Amazon Elasticsearch Service
      AWS Elastic Load Balancing (ELB)
      AWS Elastic Load Balancing (ELB)
      Memcached
      Memcached
      Redis
      Redis
      Python
      Python
      AWS Lambda
      AWS Lambda
      Amazon RDS
      Amazon RDS
      Microsoft SQL Server
      Microsoft SQL Server
      MariaDB
      MariaDB
      Amazon RDS for PostgreSQL
      Amazon RDS for PostgreSQL
      Rails
      Rails
      Ruby
      Ruby
      Heroku
      Heroku
      AWS Elastic Beanstalk
      AWS Elastic Beanstalk

      We initially started out with Heroku as our PaaS provider due to a desire to use it by our original developer for our Ruby on Rails application/website at the time. We were finding response times slow, it was painfully slow, sometimes taking 10 seconds to start loading the main page. Moving up to the next "compute" level was going to be very expensive.

      We moved our site over to AWS Elastic Beanstalk , not only did response times on the site practically become instant, our cloud bill for the application was cut in half.

      In database world we are currently using Amazon RDS for PostgreSQL also, we have both MariaDB and Microsoft SQL Server both hosted on Amazon RDS. The plan is to migrate to AWS Aurora Serverless for all 3 of those database systems.

      Additional services we use for our public applications: AWS Lambda, Python, Redis, Memcached, AWS Elastic Load Balancing (ELB), Amazon Elasticsearch Service, Amazon ElastiCache

      See more
      Interest over time
      Reviews of Microsoft SQL Server and Vitess
      No reviews found
      How developers use Microsoft SQL Server and Vitess
      Avatar of Brillium, Inc.
      Brillium, Inc. uses Microsoft SQL ServerMicrosoft SQL Server

      We've always counted on SQL Server as our database backend. It has served us well over the years. It isn't the cheapest part of our stack, but with the plethora of tools provided by 3rd parties, we have found an incredible and scalable method of keeping our data available and easy to maintain.

      Avatar of Andrew Miller
      Andrew Miller uses Microsoft SQL ServerMicrosoft SQL Server

      Defacto, industry standard for backend relational databases. Entity Framework makes designing, migrating & maintaining SQL Server databases a breeze. LocalDB is especially helpful during development.

      Avatar of David Flynn
      David Flynn uses Microsoft SQL ServerMicrosoft SQL Server

      Our core systems that we integrate with are using SQL Server 2012 / 2016 database servers. We use database views on core system databases to help build our domain model.

      Avatar of Olo
      Olo uses Microsoft SQL ServerMicrosoft SQL Server

      Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.

      Avatar of Arbor Health, LLC
      Arbor Health, LLC uses Microsoft SQL ServerMicrosoft SQL Server

      Managing script output and input, as well as data cleansing.

      How much does Microsoft SQL Server cost?
      How much does Vitess cost?
      Pricing unavailable
      Pricing unavailable
      News about Vitess
      More news