Stack Overflow
Stack Overflow

Questions tagged [legacy-database]

Legacy database refers to use of any database product, technology or schema that has been inherited, is outdated or has to be worked with because of historical or compatibility reasons.

Use this tag for questions where you want to indicate use of database product, technology or schema that has been inherited, is outdated or has to be worked with because of historical or compatibility reasons. Question examples:

128 questions
0
votes
3 answers

Convert Legacy Text Databases to SQL

At my office we have a legacy accounting system that stores all of its data in plaintext files (TXT extension) with fixed-width records. Each data file is named e.g., FILESALE.TXT. My goal is to bring this data into our MySQL server for read-only…
Raolin
  • 379
  • 1
  • 4
  • 14
0
votes
0 answers

RoR legacy database - associations crash system down

I'm struggling with my Ruby on Rails App that has a legacy database. It works in general but now I'm trying to show the associations created in the database. The two relevant scaffolds are called repo and build. One repo has many builds - so I…
cruxi
  • 819
  • 12
  • 28
0
votes
1 answer

Strategies for Rails development/test development with complex legacy schema

When developing a Rails app with a legacy schema that is in-use by an existing application, if tables have NOT NULL constraints on foreign id columns throughout the schema, in order to create/save models for tests, models need to exist for those…
Gary S. Weaver
  • 7,966
  • 4
  • 37
  • 61
0
votes
1 answer

grails with legacy database. foreign key as part of primery key

I have faced with problem of using legacy database. I have two tables connected with relation : one – to – many: Table Subscribers: create table SUBSCRIBERS ( SUBSCRIBERCODE VARCHAR2(100) not null, SUBSCRIBERNAME VARCHAR2(100), ACTIVE …
Leonid
  • 3
  • 4
0
votes
1 answer

using grails with legacy database

I faced with problem of using Grails with legacy Oracle database. I have legacy table TARGETTYPES with primary key text column TARGETTYPECODE: CREATE TABLE "TMS"."TARGETTYPES" ( "TARGETTYPECODE" VARCHAR2(100) NOT NULL ENABLE, …
Leonid
  • 3
  • 4
0
votes
1 answer

Fluent nhiberante mapping for legacy tables

How to define fluent nhibernate mapping for the Legacy tables. I have four table CTType(id GUID, Name varchar(100), DateOFbirth datetime) CTType_Legacy(id GUID, CTType_Legacy_id identity int) CTTypeMap(id GUID, createdOn datetime, CtType_id…
user1618587
  • 47
  • 1
  • 5
0
votes
1 answer

Simple associations with a legacy database in Rails 3?

I am working with a legacy database and am also reading through the Rails guides on associations. I have two models. A diary model and an animal model. diary.rb class Diary < ActiveRecord::Base establish_connection :premvet attr_accessible…
dannymcc
  • 3,744
  • 12
  • 52
  • 85
0
votes
1 answer

custom authentication backend for legacy db

Since I'm working with a legacy database I should use another model instead of the default Django contrib.auth.models.User for authentication. My model has an id field (id = models.DecimalField(...)) that is used for username and a field for…
marlen
  • 473
  • 6
  • 20
1 2 3
…
8
9