help with mssql sqlserver gem, table prefix

hi

i have a sqlserver database with multiple companies in there. the table “prefix” give you the company name:

[CompanyA$Vendor].*

[CompanyB$Vendor].*

[CompanyC$Vendor].*

how can i address the right company with AR / sqlserver gem?

thx

The preferred solution would be to adjust the database schema so as to fit the Rails Way. So have a companies table rather than multiple tables with a prefix.

Colin

cant do that :frowning:

Honestly if you can’t conform to basics of what the ORM expects Rails is probably the wrong choice for you.

It sounds like you’re trying to write a Rails app against an already existing database (which, I presume, already has other clients connected to it and changing data in it). This sounds like a bad idea.