ramondelemos
Is someone using the TDS adapter to connect to MSSQL in the production environment? What are the limitations? I need only insert and update to one single table.
Thanks! 
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Elixir, Erlang & messaging conferences from Code Sync. Next up: ElixirConf US (10–11 Sep) & Code BEAM Europe (21–22 Oct), Haarlem + online.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #ai
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixirconf-us
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 5 to 1- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
hectorsq
I am using it to read/write a legacy mssql database with about 300 tables and millions of records with no problem.
It seems that using references keyword in table migrations do not work, but that is not a big problem, you can define your columns without using references.
Many of the tables use a non integer primary key. Ecto handles them with any problem.
akoutmos
Currently using it in production and it has been working perfectly. I have a Postgres backed repo for my application data and then a TDS repo for a specific integration that I need. Running both side by side works great.
cmo
+1. I use it in a read only fashion.
The datetime types can be a bit annoying if the data is actually stored with precision of 7. If you control the creation of tables it’s not an issue.
mindok
So the only limitation I have come across is NTLM/integrated authentication. There’s been some work done to address it but I’m not sure where it is at. Otherwise, TDS works great for me in a small department line of business application.
If you do need integrated auth, MsSQLEx (GitHub - findmypast-oss/mssqlex: Microsoft SQL Server Adapter for Elixir · GitHub) works (I used it “raw”, without Ecto, vendored it into my project and tweaked some of the data type conversions to suit the project). However, it sits on top of Erlang’s ODBC implementation, and system installed drivers, so there are a few more potential points of failure. Also, text fields have limited length: Text type restricted to maximum length of 4000 · Issue #2 · findmypast-oss/mssql_ecto · GitHub. It also appears somewhat abandoned in favour of TDS. Definitely run with TDS if you can.
josevalim
That should be complete fine. A few of Dashbit clients use TDS for more complex operations than that.