Multiple databases on one server instance

[Wouter Pronk]

Hi,

just dived into Jam and really like it! I have a question though: Would it be possible to have multiple databases in 1 project? Like multiple tasks? Our current SQL set-up has multiple databases and they interact with each other f.e. to get a lookup-value.

Kr Wouter Pronk

[Dean D. Babic]

Hi, 

I think this might be possible only with linked server databases. Not something done in Jam.

Regards

D.

[Wouter Pronk]

Hi Dean,

that's not really what I mean. Within MSSQL server (and probably also other variants) there can be multiple databases. MSSQL has by default Master, MSDB, Model and tempdb as their System databases. Besides that you can create multiple databases that are not linked via linked server.

Kr Wouter

Op di 28 okt 2025 om 10:19 schreef Wouter Pronk <wjbp...@gmail.com>:

Hi,

just dived into Jam and really like it! I have a question though: Would it be possible to have multiple databases in 1 project? Like multiple tasks? Our current SQL set-up has multiple databases and they interact with each other f.e. to get a lookup-value.

Kr Wouter Pronk

--
You received this message because you are subscribed to a topic in the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/jam-py/a-EKfgqMkZg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to jam-py+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/jam-py/539cb918-36d4-4b2c-a310-6d9aece12606n%40googlegroups.com.

[Dean D. Babic]

Jam is connecting to one single database with one single user:
https://jampy-docs-v7.readthedocs.io/en/latest/intro/new_project.html

For sure you could connect to any number of databases, but you do not get CRUD on them automatically:
https://jampy-docs-v7.readthedocs.io/en/latest/how_to/how_to_data_from_other_database_tables.html

The above is needed, but was not tested yet.

D.