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
28
votes
9 answers

What does the term legacy database mean?

I read this term a lot. What exactly is a legacy database? I ask because I had thought it meant an old database like dbase or rdb, but I don't think I'm right. When looking at RoR or Django and "legacy database" integration, what does legacy…
johnny
  • 19,272
  • 52
  • 157
  • 259
15
votes
1 answer

Setting up Liquibase with MS-SQL Server

I am utilising Liquibase (www.liquibase.org) into our MVC3 SQL Server 2008 project to manage database migration/changes. However I'm stumbling on the first hurdle: Connecting to Microsoft SQL Server instance. I am looking at the quick start tutorial…
Dan Black
  • 1,167
  • 3
  • 14
  • 20
14
votes
4 answers

Hibernate chokes on missing rows when dealing with a legacy database

I am trying to implement hibernate on a legacy database (that still has a legacy PHP client), and am running into some problems because the people who wrote the original app had no idea what they were doing. The database is set up so that none of…
liam
  • 3,830
  • 6
  • 32
  • 31
8
votes
3 answers

CQRS with Legacy Systems

I'm looking to convert a relatively new web-based application with a clear domain model over to more of a CQRS style system. My new application is essentially an enhanced replacement of an older existing system. The existing systems in my…
reallyJim
  • 1,336
  • 2
  • 16
  • 32
7
votes
3 answers

Combine two unrelated tables/models with same primary key in Django

I have two unrelated tables with the same primary key. ip mac 11.11.11.11 48-C0-09-1F-9B-54 33.33.33.33 4E-10-A3-BC-B8-9D 44.44.44.44 CD-00-60-08-56-2A 55.55.55.55 23-CE-D3-B1-39-A6 ip type owner 22.22.22.22 …
Granny Aching
  • 1,295
  • 12
  • 37
7
votes
1 answer

Django automatically create primary keys for existing database tables

I have an existing database that I'm trying to access with Django. I used python manage.py inspectdb to create the models for the database. Currently I'm able to import the models into the python shell however when I try to access any of the actual…
Hudson Worden
  • 2,263
  • 8
  • 30
  • 45
7
votes
1 answer

Using raw sql queries in Rails 3 application?

I am working on migrating a legacy database into my Rails application (3.2.3). The original database comes with quite a few long sql queries for reports. For now, what I would like to do it use the sql queries in the Rails application and then one…
dannymcc
  • 3,744
  • 12
  • 52
  • 85
6
votes
0 answers

Apply XSS policy on legacy data

Our legacy application was initially designed to allow storing any html tags for customizable pages. The idea of such pages are to store any html what customers need and then at some point there is possibility to render this html data. This…
fashuser
  • 2,152
  • 3
  • 29
  • 51
6
votes
2 answers

Working with composite primary key in django project with legacy database

I have a legacy database, where some table contains composite primary key. The model I get by running manage.py inspectdb command looks like this. class MyTable(models.Model): field1_id = models.IntegerField(db_column='field1id',…
AmirM
  • 1,089
  • 1
  • 12
  • 26
6
votes
1 answer

NHibernate navigators mapped to the part of a composite key problem - legacy database usage

We have a legacy database that we cannot change. And we are trying to move to the NHibernate instead of old DataAccess layer which is a garbage and is too slow. it has tables like these: GPI table has (PU_ID, PAR_ID, Data, Data2) columns BLOCK table…
LucID
  • 151
  • 1
  • 9
6
votes
3 answers

Does Entity Framework support differing data types in the model?

I am considering to use EF to access legacy SQL Server databases installed on our customers' systems. The problem is that the databases schemas are not 100% consistent: While they all have the same (relevant) tables and fields, some numeric fields…
Heinzi
  • 167,459
  • 57
  • 363
  • 519
4
votes
1 answer

Problem mapping Grails Domain class to legacy database with TEXT field

I am trying to build a set of domain classes for a legacy database using Grails 1.3.7 and MySQL 5.1.56. I am specifying the MySQL connector in the BuildConfig.groovy file as 'mysql:mysql-connector-java:5.1.13'. The database schema has a field named…
Gene Golovchinsky
  • 6,101
  • 7
  • 53
  • 81
4
votes
1 answer

Migrating several legacy databases into one Rails app

I have several (old) Drupal-sites that need to be replaced with one single new Rails app. That new site should hold all old Drupal-content. That old Drupal-content is partly broken (due to nearly 7 years of fugly upgrades, discontinued modules and…
berkes
  • 26,996
  • 27
  • 115
  • 206
4
votes
2 answers

Django rest framework api with existing mysql database

How can I create a Django REST Framework API that connects to an already existing MySQL tables instead of creating them through modela.py. My models.py shows something like this: class Author(models.Model): first_name =…
Renya K
  • 63
  • 1
  • 3
4
votes
2 answers

JPA OneToOne association where 2 entities use composite primary keys but use different column names?

We are trying to use Hibernate with a database that uses a lot of composite keys and it's been causing us a lot of headaches. Unfortunately, we can't change the schema so we have to do a lot of additional mapping betwen our fields. We are restricted…
trafalmadorian
  • 1,660
  • 1
  • 15
  • 21
1
2 3
…
8 9