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

RIA paging with custom data layer

We're using a custom data access layer to read our domain objects (customers, orders, etc) from a database. This data access layer does not support paging or sorting. We want to publish parts of the data (for instance customers) to a Silverlight…
JohnChristoff
  • 1
0
votes
1 answer

Active Record legacy table with no primary key

I'm connecting my Rails application with a legacy database. Some of this tables don't have a primary key and I have no way to add one. Is there any way to to configure an Active Model not to have a primary key? Thanks!
Sergio D. Márquez
  • 366
  • 2
  • 17
0
votes
1 answer

Django-comments and legacy database? "OperationalError: no such table"

I'm using a legacy database (in addition to a 'normal' database), defined in my settings.py : DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'), }, …
ThePhi
  • 2,373
  • 3
  • 28
  • 38
0
votes
1 answer

CQRS and slow commands on legacy system

I am new at CQRS and want advice how to implement this over an legacy system. I have some questions: The database will remain in the legacy system. I'm guessing right that we do not have any use for Event Sourcing? Some commands will take time to…
magol
  • 6,135
  • 17
  • 65
  • 120
0
votes
1 answer

Is it good to introduce nHibernate for a legacy database in an ongoing project?

I am working on a current ongoing project where, there are two instances of the database having different schemas for some of the tables and is being used for transfer from one to another. Database schema is not well defined like, No Primary key…
sjjoshi
  • 13
  • 3
0
votes
1 answer

Rails Issue with associations using primary_key+foreign_key options

I want to access a legacy database schema from Rails. I have one table NAGIOS_OBJECTS with a primary key OBJECT_ID and one table NAGIOS_HOST_CHECKS that refers to NAGIOS_OBJECTS with a column HOST_OBJECT_ID. I thus defined the relations as…
elasticsecurity
  • 1,041
  • 1
  • 11
  • 11
0
votes
1 answer

How to map two tables and not make any changes when mapping legacy database tables in Grails?

I'm new to Grails and mapping and I have something that looks like this. I have two domain classes and I need to make a relationship between them, and when the relationship is done that no changes would be made to existing tables from my PostgreSQL…
03Ronnie04
  • 31
  • 3
0
votes
1 answer

Is the available db2 express on IBM is similar as DB2 for IBM i (db2/as400) green screen uses?

basically. I'm trying to develop a PHP app that requires an access to DB2 for IBM i (db2/as400) database. However, I'm not much familiar with DB2 for IBM i (db2/as400) environment, so I'm doing research. I'm planning to install db2 express i found…
randolfarevalo
  • 179
  • 1
  • 7
0
votes
3 answers

Pre-done SQLs to be converted to Rails' style moduls

I am a Rails newbie and would really appreciate if someone converted these SQLs to complete modules for rails. I know its a lot to ask but I can't just use find_by_sql for all of them. Or can I? These are the SQLs (they run on MS-SQL): SELECT…
Hoornet
  • 1,398
  • 3
  • 18
  • 30
0
votes
2 answers

NHibernate Legacy Database Mappings Impossible?

I'm hoping someone can help me with mapping a legacy database. The problem I'm describing here has plagued others, yet I was unable to find a real good solution around the web. DISCLAIMER: this is a legacy DB. I have no control over the…
Corey Coogan
  • 1,569
  • 2
  • 17
  • 31
0
votes
2 answers

loop through mysql database records and change phone formats

I'm working on a legacy database table that has a phone no. field but the problem is that all the entries (over 4k) are in varying formats. I was wondering if there was a quick way to fix them by looping through the records using PHP and updating…
Digital Craft Studios
  • 230
  • 1
  • 2
  • 12
0
votes
1 answer

sqlalchemy 0.6 legacy database access?

I feel like this should be simple, but i cant find a single example of it being done. As an example I have the following existing tables: CREATE TABLE `source` ( `source_id` tinyint(3) unsigned NOT NULL auto_increment, `name` varchar(40) default…
lostincode
  • 479
  • 6
  • 16
0
votes
1 answer

Foreign Key does not exist. Show entry in Admin

I have to work with a legacy database and have the following problem. My model has a foreign key to the User Model: class History(models.Model): uid = models.ForeignKey(User, to_field='username', db_column='uid') That seems to work. The…
ilse2005
  • 11,189
  • 5
  • 51
  • 75
0
votes
2 answers

Devise + Legacy DB: "password" column

I'm trying to slowly migrate an old CakePHP site to Rails 4. Because of the massive effort required, the site needs to be moved over gradually, only migrating a single piece at a time, and starting with Active Admin. I've seen plenty of questions…
charredUtensil
  • 153
  • 1
  • 11
0
votes
1 answer

ORM framework to legacy database without SQL support

We're going to start writing C# programs against a old legacy database from the early 1980s. There is no support for SQL or relationships, and communication with it is through Telnet commands. I'm thinking of using some sort of ORM framework, or…
magol
  • 6,135
  • 17
  • 65
  • 120
1 2 3
…
8
9