Help with mssql sqlserver gem, table prefix

Rails
1

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

2

On 26 November 2014 at 16:58, tom [email protected] wrote:

[CompanyC$Vendor].*

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

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

3

cant do that :frowning:

4

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.

i have a sqlserver database with multiple companies in there. the table

To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLtsj86dWJU-Bw0byFwRBoNuHnEt1dDeyyj0R7b7EQaJzA%40mail.gmail.com
https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLtsj86dWJU-Bw0byFwRBoNuHnEt1dDeyyj0R7b7EQaJzA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout
https://groups.google.com/d/optout.

–
You received this message because you are subscribed to the Google G. “Ruby
on Rails: Talk” group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected]
mailto:[email protected].
To post to this group, send email to [email protected]
mailto:[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/CADQqhMcmDvunXaxDuAoqmEj9aJztT_s9n%3DzqtJvJw0eyN1tKpg%40mail.gmail.com
https://groups.google.com/d/msgid/rubyonrails-talk/CADQqhMcmDvunXaxDuAoqmEj9aJztT_s9n%3DzqtJvJw0eyN1tKpg%40mail.gmail.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout
https://groups.google.com/d/optout.

Jason Fleetwood-Boldt
[email protected]

All material © Jason Fleetwood-Boldt 2014. Public conversations may be
turned into blog posts (original poster information will be made
anonymous). Email [email protected] with questions/concerns about
this.