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
1
vote
0 answers

Troubles using ManyToManyField with a legacy database

The problem is that, I related (Legacy) table to (UserProfile) django models with M2MField and also through an intermediary table, but there seems to be no relation generated. Legacy table is just one table with no other relations. I am using…
Leonard2
  • 894
  • 8
  • 21
1
vote
1 answer

Composite Key and mapping in grails 2.2.5 with legacy database

I have 4 tables. osiguranje_paket, atribut, tip_unosa, razna_polja. osiguranje_paket, atribut, tip_unosa are Parents of razna_polja table. razna_polja table has composite key that is consisted from two primary keys (osgp_id = osiguranje_paket table…
03Ronnie04
  • 31
  • 3
1
vote
2 answers

Un-nesting nested MS Access sql queries

I've been given a small Access database to work on. The guy who created it wrote many custom queries to generate reports. I've been tasked with modifying the reports and the guy who initially wrote the queries is gone and left no documentation. …
Shaun Poore
  • 612
  • 11
  • 23
1
vote
1 answer

Grails: Legacy DB - Record with composite Id won't update

I'm having problems trying to update a record on a Grails 2.3.7 Project I don't want to modify the fields that are part of the composite Id, I just want to update the other fields. Just one class, few properties, but every time I try to update, it…
Johnny C.
  • 368
  • 1
  • 5
  • 20
1
vote
0 answers

How does one test if a backup of an `.mdb` file is good in an automated manner?

I make a copy of an .mdb database (and it's other partition) every night, and test it by opening it up to see if it works. By "make a copy" I mean: I kick all the users out of the database who are connected via RDP (not automated...) Rename both…
leeand00
  • 25,510
  • 39
  • 140
  • 297
1
vote
1 answer

Django with a legacy database

I need to build a django project on top of an existing database. I'll use inspectdb as explained in the django docs and then syncdb to create the django required tables. Is there a way to keep track of the django specific tables (admin permissions,…
pablo
  • 2,719
  • 11
  • 49
  • 67
1
vote
1 answer

Django: model for unusual table relationship in a legacy DB

I'm doing my first Django project and am wrestling with a legacy DB from a 3rd party program. The DB has a slightly unusual table structure for one section I'm trying to get to grips with. The basic table layout is as follows: PERSON ------ z_pk int…
gmerrall
  • 390
  • 1
  • 8
1
vote
2 answers

Django & customising a legacy database

I'm currently working on a project to implement a Django interface to an existing calendar application. The calendar application has MySQL as the backend DB. In our custom application we would like to modify/extend the data in one of the tables used…
Martin
  • 7,089
  • 3
  • 28
  • 43
1
vote
1 answer

How to represent a legacy database using Hibernate?

I have the follow legacy database structure and content: order parameter value -------------------------------- 1 user_login user 1 user_password 123456 1 user_level basic 2 user_login admin 2 …
deldev
  • 1,296
  • 18
  • 27
1
vote
1 answer

How do I work with a LEGACY database in Rails?

I'm working on a Rails web site that profiles stock mutual funds and ETFs. I ALREADY HAVE a separate Ruby script that runs nightly and populates a Postgres database with data on these mutual funds and ETFs. Chapter 6 of Rails tutorial isn't quite…
jhsu802701
  • 573
  • 1
  • 7
  • 23
1
vote
1 answer

MySQL schema to schema syncronization through triggers?

Quick note: I have 19 days to figure my client's problems out. Background: Client hired a contractor who boasted he could get a new App out the door in 3 months. Two months and some days later I'm brought in and the individual was let go; there…
David
  • 17,673
  • 10
  • 68
  • 97
1
vote
2 answers

Using RoR with a legacy table that uses E-A-V

I'm needing to connect to a legacy database and pull a subset of data from a table that uses the entity-attribute-value model to store a contact's information. The table looks like the following: subscriberid fieldid data 1 …
Wayne Molina
  • 19,158
  • 26
  • 98
  • 163
1
vote
2 answers

Rails 3 - Column Names (Legacy Database)

Possible Duplicate: Alias for column names in Rails I'm writing a module of ActiveRecord models to access a MySQL legacy database. My problem is that the database has a column naming convention that looks like this: groupID, metaGroupName,…
jtdoepke
  • 31
  • 2
  • 6
1
vote
1 answer

Issues querying date column from legacy Oracle database and ActiveRecord

I'm new to rails and still learning how it all works. I'm trying retrieve a list of years from a date column in an legacy Oracle database so I can get a list of all the years an object has been entered. The Oracle database is 10g and I'm using rails…
dspencer
  • 918
  • 2
  • 8
  • 38
0
votes
1 answer

How to access data in old DOS RapidFile data files

I need to get access to some data that is stored in an old DOS format. Specifically using Ashton-Tate's RapidFile format. Does anyone know if there are ADO drivers or any other more "modern" data access technology that will enable me to read the…
Raoul
  • 1,098
  • 1
  • 8
  • 12
1 2 3
…
8 9