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
2
votes
10 answers

How to modernize an enormous legacy database?

I have a question, just looking for suggestions here. So, my application is 'modernizing' a desktop application by converting it to the web, with an ICEFaces UI and server side written in Java. However, they are keeping around the same Oracle…
sma
  • 9,449
  • 8
  • 51
  • 80
2
votes
2 answers

Rails 4, sqlserver-adapter: using alias_attribute to rename legacy attributes

Dealing with a legacy system that has non-Rails conventional naming. Note that all tables and attributes are UPPERCASE, which in the sqlserver-adapter means that ID is NOT the same as id. I had thought that alias_attribute :new, :OLD allowed you to…
Dan L
  • 4,319
  • 5
  • 41
  • 74
2
votes
2 answers

Problems using a legacy database with a new rails application

What are the usual problems / stumbling blocks / issues / drawbacks when using a legacy database with a new rails application? We have to decide between using an old database or writing migration scripts to bring data from old database to new…
Kalyan
  • 35
  • 5
2
votes
2 answers

Dump all Raima db_VISTA Version 3.20 data to text

A friend has an old program that no longer works but he wants to recover the data. From the file's header I've found out that it's a legacy Raima db_VISTA Version 3.20 database. I've found this similar question How can I export data in a legacy DOS…
Eduardo Molteni
  • 38,786
  • 23
  • 141
  • 206
2
votes
2 answers

Rails 4 oracle enhanced adapter many to many propagating data to the pivot table

First things first Using: rails4 oracle enhanced adapter rails4 branch I have a many to many relationship mapped on an existing database. My models look as such: class EventMap < ActiveRecord::Base self.table_name="TAKE_PART" …
mahatmanich
  • 10,791
  • 5
  • 63
  • 82
2
votes
4 answers

How to gracefully handle "Mysql2::Error: Invalid date" in ActiveRecord?

I'm building a Rails 3.2 app upon a legacy database which also has some broken records in different tables. One of the issues giving the most headache is that it includes invalid dates. I've setup a sandbox which I manually fixed one time to get my…
hurikhan77
  • 5,881
  • 3
  • 32
  • 47
2
votes
2 answers

Can I use nHibernate with a legacy-database with no referential-integrity?

If I have a legacy database with no referential-integrity or keys and it uses stored procedures for all external access is there any point in using nHibernate to persist entities (object-graphs)? Plus, the SP's not only contain CRUD operations but…
AwkwardCoder
  • 24,893
  • 27
  • 82
  • 152
2
votes
1 answer

Setting table name in namespace model

I have some namespaced models which I'm trying to override the default rails table name for them because I'm connecting to an existing legacy database. My models are: /app/models/licenses.rb module Licenses def self.table_name_prefix '' …
dspencer
  • 918
  • 2
  • 8
  • 38
2
votes
2 answers

Ruby on Rails adding double quotes to "find" function

I'm new to ruby on rails, and I'm having an issue with the find function. I created a new web app which connects to a legacy Oracle database using the oracle enhanced adapter gem. When I run the following commands in the rails console, I get data…
dspencer
  • 918
  • 2
  • 8
  • 38
1
vote
1 answer

NHibernate, save null reference value in DB as 0 (zero)

I found this example of a tuplizer to do save 0 when saving null relationships. This is needed since I'm working on a app on a legacy database schema. I tried the tuplizer here:…
Stamppot
  • 183
  • 1
  • 10
1
vote
1 answer

Grails project: Gorm or JPA/Hibernate annotations for legacy db mapping?

In a grails app, I have to create a bunch of grails domain classes mapped to a very old db. This very old db is using a lots of "funky" unreadable names for tables and columns. These tables contains (too) often (too) many columns. I was thinking of…
Guillaume
  • 5,488
  • 11
  • 47
  • 83
1
vote
0 answers

Legacy VB app with no source code accesses MSSQL with 'sa' and a 6-digit password. Work around for password policy?

I have a legacy VB app without any source code that has the 'sa' user and a 6-digit password hard-coded into it. I would like to use an up-to-date MSSQL but I am getting stuck on the password length policies in more modern MSSQL versions. I've tried…
jstark
  • 11
  • 1
1
vote
0 answers

mysql/mariadb strict_trans_table mode. Log before enabling

I have an older legacy application running a old version of MariaDB(10.1). Before doing an upgrade i would like to make sure i "catch" all the insertion fails, auto-truncation etc. I've been searching for a way to log all of these events so that i…
Wel Rachid
  • 23
  • 7
1
vote
0 answers

Django content type table data migration while upgrading from 1.6 to 2.2 with legacy database

I am Upgrading my django project from version 1.6 to 2.2. I'm already having a legacy database with lot of generic relations in the project. Can anyone help to how should the django_content_type table should be populated. If I will go for new…
John Joseph
  • 11
  • 1
1
vote
1 answer

NHibernate on a table with two "primary" keys

I'm learning NHibernate in order to layer it over a rather peculiar legacy database. Other applications use the same live database, so I can't make changes that will affect them. I've run into a problem because one table, which represents hardware…
JohnCC
  • 615
  • 7
  • 20
1 2
3
…
8 9