Extract from Azure SQL & Scheme

Help
1

Hi
I have 2 questions that I can’t find any answers to in the doc:

  1. Import from Azure SQL
    Currently we are having all of our customers data in Azure SQL databases, and generate fact tables for reporting. Is there an easy way to load data from Azure SQL into MemSql? I know that you can put it in a blob and make a pipeline for it… but seems like an extra step.
    I’ll like to keep my transactions in Azure and only export whats needed for reporting to MemSql (size limitation)

  2. Scheme for MemSql
    Which scheme does MemSQL prefer? A star scheme ? a more normalized one, or a (wide) fact table with redundant column information.?

2

Hi GoFact!

Currently, MemSQL does not support change data capture (CDC) from Azure SQL to MemSQL, although this feature is in the works. However, perhaps other team members of mine could provide some additional input on how you could move data from Azure SQL to MemSQL.

Secondly, here are some resource regarding schemas and table structure to use for MemSQL:

  1. Third Normal Form, Star Schema, and a Performance Centric Data Strategy

  2. SingleStoreDB Cloud · SingleStore Documentation

3

Thanks. Looking forward to the data move from SQL :slight_smile:

1 Like