Importing From MS SQL Server - Datatype Mapping

Gallus
SQL-Fighter

We have the case that we have an application in the cloud (CRM Dynamics), wich uses Microsoft Data-Export-Services to export the Data from the CRM Application into an MS SQL Database in the Azure cloud.

We would like to import the data from this Azure MS SQL DB to Exasol. Unfortunately I could not find a data-type mapping documentation from MS SQL to Exasol (From Teradata to Exasol I found one: https://docs.exasol.com/migration_guides/teradata/execution/datatypemapping.htm)

Would anyone know whether such a documentation exists? If not how would you suggest to map the following MS SQL datatypes

  • uniqueidentifier --> varchar(2'000'000)
  • nvarchar(max) --> varchar(2'000'000)
  • bit -->  integer
  • bigint --> integer

 

Kind Regards

Gallus

2 ACCEPTED SOLUTIONS

Accepted Solutions

exa-Nico
Community Manager
Community Manager

Hi @Gallus ,

We have some migration scripts which also do some explicit data type mapping here:

https://github.com/exasol/database-migration/blob/master/sqlserver_to_exasol.sql

For example, bit is mapped to DECIMAL(1,0) and bigint is mapped to a DECIMAL. 

You can go through the script and try it with your table to see what the equivalent DDL in Exasol would be. Hope it helps!

Nico

Sports Enthusiast. Database Guy. Member of Team Exasol.
Having trouble? Just let me know!

Please Give Kudos if you find this post useful and also mark this as Accepted Solution if this is the required solution

View solution in original post

exa-Kristof
Team Exasol
Team Exasol
4 REPLIES 4

exa-Nico
Community Manager
Community Manager

Hi @Gallus ,

We have some migration scripts which also do some explicit data type mapping here:

https://github.com/exasol/database-migration/blob/master/sqlserver_to_exasol.sql

For example, bit is mapped to DECIMAL(1,0) and bigint is mapped to a DECIMAL. 

You can go through the script and try it with your table to see what the equivalent DDL in Exasol would be. Hope it helps!

Nico

Sports Enthusiast. Database Guy. Member of Team Exasol.
Having trouble? Just let me know!

Please Give Kudos if you find this post useful and also mark this as Accepted Solution if this is the required solution

View solution in original post

exa-Kristof
Team Exasol
Team Exasol

Gallus
SQL-Fighter

Hello @exa-Kristof and @exa-Nico 

Many thanks for your answers, this helped me. 

I usually go to the exasol-documentation website (https://docs.exasol.com/home.htm), from there I was not able to find these links. I usually don't go directly to github. Perhaps the search on the doc-site could be enhanded to also cover the information on github?

exa-Nico
Community Manager
Community Manager

I would love that, but like always, there are some other technical dependencies that make it challenging. For a quick "win" though, we can enhance pages like this and make it more explicit that the github repos also contain data type mapping information. It's briefly mentioned already, but doesn't mention the other use cases. I'll open an internal ticket for that 🙂 

Sports Enthusiast. Database Guy. Member of Team Exasol.
Having trouble? Just let me know!

Please Give Kudos if you find this post useful and also mark this as Accepted Solution if this is the required solution