MSSQL support for ecto-3

Questions & Help Questions
, ,
1

Hi ElixirCommunity,

We have a data-centric elixir project.
Currenlty we are using ecto-3, ecto_sql with postgres and oracle.
We need to fetch a lot of data from mssql but currently there is no adapter ready for ecto-3.

However, there is an adapter which relies on ecto-2 and support mssql.
Is there any way to use that adapter in same project ?

If not, what is the best way to fetch data from MSSQL database and use that data for api-calls or transferring that data to other dbs.

2

If you want to connect to MSSQL, this article may be of relevance to you: GitHub - findmypast-oss/mssqlex: Microsoft SQL Server Adapter for Elixir · GitHub

Once you have a driver that works in place, there are many things you can do. Recently I just heard in Elixir Mix Daniel Serrano using Flow to read in parallel from a DB.

Link to Flow

I also know some people like GraphQL and the author of Search is rather active in this forum, as well as a really nice guy too ! (which I could remember his username, i’m sure someone will!)

So you have quite a number of options, it all depends on how much time you’re wiling to invest.

3

The author of the graphql book is @benwilson512 :slight_smile:

4

Thanks for reply @Fl4m3Ph03n1x,

Our current apis are graphql-apis only :slight_smile: It’s great.
The only problem we are facing is - how to make mssql work!!!

One possible option is to downgrade everything to ecto-2 which doesn’t feel right :frowning:
And I’m unable to make adapter work with ecto-3 and ecto-sql :expressionless:

Any example implementation or reference about ecto-sql and mssql or tds would help a lot.

5

We don’t use mssql here nor ecto, so I am afraid I can’t be of much help. I did find a couple of articles that may help you out:

  1. https://medium.com/asolvi/going-functional-part-iii-using-elixir-and-ecto-with-azure-sql-4e66b677f998
  2. https://medium.com/asolvi/update-azure-sql-with-elixir-c77da7cc4197 (updated version of the first article, but the journey is what matters!)

If this still doesn’t help, I recommend you create an issue in the github projects and ask the authors for some guidance or examples.

Reading the test files usually helps as well:

https://github.com/findmypast-oss/mssqlex/blob/master/test/mssqlex/query_test.exs