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

Django keeps recreating foreign key field for legacy database with migrations command

I'm quite new to Django development. I'm working with a legacy database created with MySQL. Now I'm facing a problems with Django migrations. I have few tables that are using foreign keys for the reference to another table. Now if I allow Django to…
Usama Saeed
  • 331
  • 4
  • 16
1
vote
1 answer

Rails 3: DataObjects::SQLError -- How do I stop these from producing errors on *warnings*?

When I insert just a few fields to a table in a legacy database schema (via DataMapper), I'm getting the following: DataObjects::SQLError "Field 'activationcode' doesn't have a default value" I didn't actually specify a value for that field, but…
d11wtq
  • 34,788
  • 19
  • 120
  • 195
1
vote
2 answers

Django Zero Value on ForeignKey Field

I'm working on very badly designed legacy database. On some of the tables not only can the foreign keys be null (which is OK) they can be 0 too. I mapped one of these tables to a Model it returns the desired None value when it is Null in the table…
Siavash
  • 358
  • 1
  • 5
  • 19
1
vote
1 answer

Entity Framework 4.0 Many-Many relationship Using Non-Primary Key

I am trying to build a generic repository using Entity Framework 4.0 using a legacy MS SQL database I have inherited. A pretty familiar scenario. I need to add category information to a fairly long list of existing items. The items can belong to…
Peter Samuel
  • 282
  • 1
  • 4
  • 11
1
vote
2 answers

Mapping one to many collection with Foreign Key to Foreign key

I'm mapping a legacy database with nhibernate and having some problems with mapping a relation. The two classes look like this public class Questionnaire { public int Id {get; set;} public string FormCode {get; set;} public…
pythonandchips
  • 2,175
  • 2
  • 25
  • 28
1
vote
1 answer

Why indpectdb in django didn't create all table models?

I have restored the database "AdventureWorks2017" into SQL-Server-2017 , which contains a lot of tables such as: dbo.AWBuildVersion dbo.DatabaseLog dbo.ErrorLog HumanResources.Department HumanResources.Employee ... I am using…
Amir.S
  • 719
  • 8
  • 15
1
vote
2 answers

Django MultipleObjectsReturned while using a legacy database

I am using Djano to develop a simple web app to display and manage database data. I hooked up a MySQL db and used inspectdb to auto generate a model based on the database tables and this is what I got back, which looks good. # This is an…
Ian Hoyos
  • 95
  • 1
  • 2
  • 8
1
vote
0 answers

Migrating Wordpress legacy app to RoR with Devise. Password hash

I have a database with hundreds of users on an old Wordpress application that I want to migrate to a new RoR application. I am stuck with the passwords. Wordpress has a different encryption than Devise. Its pattern starts with "$P$". How can I do to…
Luiz Henrique
  • 877
  • 8
  • 25
1
vote
1 answer

Installing very old versions with brew

There is a really beautiful question written here: Homebrew install specific version of formula?, however the solution is not working for me, I believe due to changes in brew. I'm currently trying to install version 1.7.5 of elastic search onto my…
haxonek
  • 174
  • 1
  • 2
  • 17
1
vote
0 answers

Avoid creation, changes etc. on legacy database tables

My grails-project contains also tables from a legacy database. These tables must not be touched in any way by the grails-app. Even when running in the develop environment the tables must be untouched. How can that be done?
larand
  • 773
  • 1
  • 9
  • 26
1
vote
0 answers

Retain 'plain' permalinks for Wordpress from import DB

I'm in the process of migrating an 'old' website into WordPress the does not use 'friendly permalinks'. Presently the page URL's read like '.../index.php?article=0058280". How can I retain the legacy URL's for old imported posts (there are over 50k…
user3738962
  • 81
  • 1
  • 1
  • 2
1
vote
1 answer

Legacy database - should I be using NHibernate?

I am stuck with a legacy database involving composite keys and there is no room to modify the db. The problem seems to be that one part of the key is also used for each foreign key. So if I have tables A and B like this: A company (PK) aId…
Nils
  • 9,682
  • 6
  • 46
  • 72
1
vote
2 answers

How to implement multivalued attribute in Django?

I have a legacy database with the following tables: person person_id (PK) | first_name | last_name 1 | John | Doe 2 | David | Bentley phonenumbers person_id (FK,PK) | phone_number (PK) | area_code…
Peter LT
  • 13
  • 4
1
vote
1 answer

Spring Security Grails Plugin working with existing Database Schema?

I recently ran into a situation where I wanted to implement Grails + Spring Security over an existing database schema. The Database already had a users table, a roles based table and the relationship roles+user table. I am able to map the users…
Mike Croteau
  • 1,062
  • 2
  • 16
  • 43
1
vote
0 answers

migrate in django to legacy database gives error

Background info: I am quite beginner with django, better equipped with python and quite beginner in mysql (and thus mariaDB) as well. I work in Windows 7 environment with the following versions: django 1.9.1 mariaDB 10.0.20 Python…
scinaya
  • 61
  • 1
  • 6
1 2 3
…
8 9