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
1 answer

Entity Framework 4.1 - Mapping bad schema

So I have a badly formatted schema that I can't touch right now because of a lot of legacy code dependencies. Supposed I have a table Test and it has a column IsValid that is declared type int. I want the poco domain object to have the proper intent…
junkyspace
  • 365
  • 4
  • 15
0
votes
1 answer

Django migrations foreign key mismatch with legacy database

Hej all, I am trying to integrate a SQLite legacy database with Django v3.1.2, and so far it's pretty painful (new to django, so apologies if it's sth obvious). I assume something is wrong with my database schema or with the migration process. So…
sequence_hard
  • 5,115
  • 10
  • 30
  • 50
0
votes
0 answers

Where to find Microsoft Access 2003?

I have an old MS Access 97 database that I need to open in 2020. Apparently it is possible by following an official procedure described…
SomJura
  • 336
  • 1
  • 3
  • 13
0
votes
1 answer

Legacy SSMigrationAssistant for Oracle 7.3?

Im unable to get any connectivity to Oracle 7.3 using the current SSMA from Microsoft. There is no legacy download anymore and i think i need an older version, 6.0. I keep getting two-task connection potocol errors when I use the tnsnames method to…
Christopher Gibson
  • 68
  • 9
0
votes
0 answers

Why django inspectdb doesn't create foreign keys correctly on an existing database?

I want to use an existing database but after inspectdb generates an auto generated models file the relations of the models are not according to django. For example: user_id = models.IntegerField(blank=True, null=True) which should be a foreign…
Abdul Haseeb
  • 1
  • 2
0
votes
1 answer

Fluent NHibernate with Legacy database compound question

I know these questions been asked numerous times, but some of the questions are 6+ months, and products evolve. I have a database schema, newly designed by some real pro's, beautiful in it's construction, sitting in Enterprise Architect, ready to…
scope_creep
  • 4,213
  • 11
  • 35
  • 64
0
votes
1 answer

How to fix an API using jsonapi-resources that is responding with mismatch type and not allowing me to create records?

I have a problem with Mismatch types in my API everytime I want to create a new item. It happens in 2 places: when I try to POST a new item POST http://localhost:8060/datasets/ { "data": { "type": "datasets", …
kriztean
  • 229
  • 3
  • 13
0
votes
1 answer

Django: Can't import multiply legacy databases

So I am trying to stand up a Django site that will query my DBs and return reports. I have 5 legacy DBs that need to be imported. I set one as default and ran inspectdb. This one imported correctly and now is all set. I ran inspectdb against the…
Joe
  • 2,641
  • 5
  • 22
  • 43
0
votes
1 answer

How to Map a database where Primary keys are made of 2 fields (one set on insert, one Identity)?

I am currently working on an old ASP application with a SQL Server 2000 database which we are trying to port to newer technologies using .NET and NHibernate. In that DB, all the tables have an composite ID made like this : CREATE TABLE…
tsimbalar
  • 5,790
  • 6
  • 37
  • 61
0
votes
1 answer

Grails, legacy database fails to get correct type of ID

There is a lot of problems using tables from a legacy DB. One is a table with name "RoleType" which has it's ID named "RoleType" Here is the important fragment of the domain class: class RoleType { int roleType .... static mapping = { …
larand
  • 773
  • 1
  • 9
  • 26
0
votes
2 answers

Convert from .NET MVC 2 to Django

Our .NET MVC 2 app is over-engineered. That data models are solid, but everything else is a mess. Is there away to "point" Django at our MS SQL Database, and have it generate the basic scaffolding and Admin interfaces from our existing DB…
Dave
  • 1
0
votes
0 answers

Entity Framework Model Mapping With Legacy Database and Constant

I'm using EF6 over a DB that's over 15 years old. I did not make this architecture decision. All of my experience with EF has been code-first, with models I've created myself. One of our tables has a reference table that has some info needed in…
Vern Halen
  • 53
  • 1
  • 8
0
votes
1 answer

Django with legacy database - how to work with DB sequences?

Given a database table that was created using this SQL query: CREATE TABLE Bill ( Time DATE NOT NULL , Address VARCHAR2 (60) NOT NULL , ID NUMBER NOT NULL ) ; ALTER TABLE Bill ADD CONSTRAINT Bill_PK PRIMARY KEY ( ID )…
Jakub Nurski
  • 473
  • 4
  • 18
0
votes
0 answers

Creating changelog in Liquibase with MSSQLSERVER

Hi I am using Liquibase (www.liquibase.org) with SQL Server 2008 project to manage database migration/changes. While using the below liquibase command, I am getting an error "Unexpected error running Liquibase: Premature end of file." liquibase…
Sriks
  • 1,669
  • 6
  • 26
  • 40
0
votes
3 answers

Should I give up on frameworks if I have legacy databases?

Everywhere I turn it seems that frameworks (in any language) are tailored to new implementations. It also seems that using ORMs with the frameworks with legacy databases is not a normal thing to do. I have databases, some 20 years old that I need a…
johnny
  • 19,272
  • 52
  • 157
  • 259
1 2 3
…
8 9