StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PORails. Working with data from existing MS SQL database :(
text
Body
copied!<p>This is my first post so please be patient with me... :)</p> <p>I am learning rails at the moment and took an internal project to help me and get proper handson practice.</p> <p>The situation is like this: We have an existing MS SQL Server 2000 DB with bunch of customers. Usual stuff. I don't know who designed it but there is a huge table "Customer" where all the details are.</p> <p>Soon we'll be moving customers out to a new company and need to track the movement. So the application should have the snapshot of the movement details for a particular customer: whether he was called on the phone, talked to or contacted by other means. Notes of the conversation. Whether he agreed to move. Etc ...</p> <p>So the original customer data should be pooled from MS SQL and all the new tracking data should be in proper new rails DB. I was considering few things: 1. Pooling customer records from old DB and doing the rest of the work in the new one. This one no good as my research shows that rails cannot work with two DBs at the same time. 2. Connecting to just old MS SQL and doing all the work there creating new necessary tables. This one seems to be a lot of trouble. "odbc" adapter gives me errors. "sqlserver" adapter does not work with mssql 2000 Plus, I predict lots of troublew working with existing MS DB. 3. This method I think is the most rational. Dump the customer table from the old MS SQL DB to CVS and import it to the new sqlite db created for the rails app.</p> <p>Please let me know if you think of other methods to solve this problem.</p> <p>With the third method I still see many problems which I would like help if possible. For instance, rails creates additional fields in the table so the data import might not work. Or am I mistaken? Is the third method sounds doable for you? Do you see any pitfalls. Suggestions?</p> <p>Thanks very much. </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload