Microsoft SQL Server (MS SQL) to SingleStore Migration

SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to SingleStore.

Databases:

  • Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008, 2005 and 2000, Azure SQL Database, Azure Synapse
  • SingleStore 8.x and 7.x

Migration Reference

Data Types

Converting datetime data types:

SQL Server SingleStore
1 DATETIME Date and time with fraction (milliseconds) DATETIME(6) Only precision of 6 is accepted

Other data types:

SQL Server SingleStore
1 SYSNAME System-defined type for identifiers NVARCHAR(128)

Built-in SQL Functions

Converting datetime functions:

SQL Server SingleStore
6 GETDATE() Get the current date and time NOW(6) Only precision of 6 is accepted

CREATE TABLE Statement

Converting CREATE TABLE statement keywords and clauses:

SQL Server SingleStore
1 col AS exp Computed column col AS exp PERSISTED AUTO

SELECT Statement

Converting SQL queries from SQL Server to SingleStore:

SQL Server SingleStore
1 LOOP | HASH | MERGE Join hints i.e. INNER LOOP JOIN Removed