user20230119
This is what I did to use ash_sqlite with mssql and Ecto.Adapter.Tds after asking about mssql in the discord.
Where Next?
Trending in Discussions
Other Trending Topics
Latest Ash Threads
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
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
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.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Master modern tools, write cleaner code, and tackle real-world challenges.
**Building the future of software with AI, trust, and human connection.**
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 6- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
zachdaniel
We should finish the find and replace and publish a new repo for it at some point
03juan
Yes please do. I’m interested in integrating my app to an Oracle Primavera P6 server instantiated on MSSQL and would be very keen to guinea-pig the library.
user20230119
After reading this post, I don’t know if we should start with AshPostgres or AshSqlite as a base for MSSQL.
zachdaniel
It depends TBH. I don’t know much about MSSQL myself. Can it do lateral joins? Is there a function for raising errors (like
RAISE EXCEPTIONin pg)? Does it do save points? If so, copying postgres would be the best starting point. Otherwise, I’d probably start w/ash_sqlite.gazzer82
Sorry to drag this back up, how did you get on with this @user20230119 in the end? I have a business application I would like to attempt porting to Ash that primarily uses Postgres, but has some legacy records in MSSQL that I need to query only, and this seems like a relatively easy fix for me to implement?
user20230119
I only got as far as forking
ash_sqliteand changing the repo adapter.I had an issue where the ID columns for my tables were
intand notbigintthatash_sqliteuses by default.Someone else got far with ManualRead.