Hi All, I'm in the process of migrating a MySQL database from Debian to windows vista (localhost using Apache - installed and running via EasyPHP). The database is essentially a carbon copy, every entry is the same, however when I try to access the database, I get some strange errors (for example, in some cases the first few entries in...
Hi, having to work in two parallel environments, developement and production, I want to use the same TableAdapter to connect to different databases (two Oracle databases running on different servers) with the very same structure. How is this possible? Thanks. ...
I need to merge two two mysql databases with identical schema. I am looking for some tool that can read database meta-data (PK, FK) and automatically generate new PKs, updating all the FKs automatically. ...
I'm writing a lazy list to retrieve items from a database with a given criteria and a given paging (start index and number of items desired). At the instantiation of the list I count the total number of items in the mapped table, so that I have an initial size of the list (initial, because the list permits the addition and removal of it...
This is a question which has been asked before (large-text-and-images-in-sql) but mainly for data which will be changed. In my case the data will be stored and never changed. Just seems sensible to keep everything together. Are there any reasons why I should not store static binary data in a database? Assuming it is a sensible thing t...
I was thinking about some stuff lately and I was wondering what would be the RIGHT way to do something like the following scenario (I'm sure it is a quite common thing for DB guys to do something like it). Let's say you have a products table, something like this (MySQL): CREATE TABLE `products` ( `id` int(11) NOT NULL auto_increme...
Background: iSeries version of DB2. In every environment, there is a table containing positional column information about other tables. As the data in this table is static and has to be re-generated every time a table is altered, problems can occur if it is out of step. All the positional data exists in QSYS2.SYSTABLES and QSYS2.SYSCOLU...
how can i monitor rows being deleted(say 20 rows)? consider, i am a dba and monitoring an oracle database.. i have to get an alert if someone deletes more than 20 rows.. i should avoid a trigger since it is costly.. is there any other way around? how can i parse the redo log and trap the sql that might have caused a bulk row delete? m...
I'm trying to drop a database from PgAdmin 3 and I get this error message: ERROR: can't delete current database SQL state: 55006 how can I force the delete/fix this error, of this database? ...
I want some help that is related to J2ME. I don’t know a lot about J2ME and now I am required to do a mobile application (it is a course project). My application must be connected to the database, so I don’t know what should I do to do this project! Some students said that I should to do a web server that connects to the database and ...
EDIT: To people building tagging systems. Don't read this. It is not what you are looking for. I asked this when I wasn't aware that RDBMS all have their own optimization methods, just use a simple many to many scheme. I have a posting system that has millions of posts. Each post can have an infinite number of tags associated with it. ...
If .NET 2.0 nullable types was there from version 1, will DBNull.Value not be needed in the first place? Or RDBMS's null has no bearing with .NET's null? That is DBNull.Value will still be needed anyhow, regardless of .NET version 1 already have nullable types. ...
We are about to start a project which involves using a Sql Server 2005 with lakhs of records. In the past I have used NHibernate with good results. But now I am evaluating Linq to entity for the data access. I have these questions on L2E, How good is the caching that the L2E does compared to NHibernate (basically how is the performanc...
How would you tackle the following storage and retrieval problem? Roughly 2.000.000 rows will be added each day (365 days/year) with the following information per row: id (unique row identifier) entity_id (takes on values between 1 and 2.000.000 inclusive) date_id (incremented with one each day - will take on values between 1 and 3.65...
I couldn't find a proper discussion thread on this topic, so I'm going to go ahead and ask here. Problem: I have a select query that returns a result of size 100,000+. The user wants to view all this data, but obviously I can't give it to him all at once. I also don't want to store so much data on the client's memory. I want the user to...
Apart from the google/bigtable scenario, when shouldn't you use a relational database? Why not, and what should you use? (did you learn 'the hard way'?) ...
I'm wondering if anyone out there as built a custom script or stored procedure that will accept a field and an XPath expression to return. Even if it's really clumsy, I'll take it. Something like this: FindByXPath(fieldName, query); Which I would give values: FindByXPath([xmlContent], '/root/customer/country[@attribute]'); All I ...
Can NHibernate be used as ORM tool for MS Access? We are using Nhibernate to access Sql Server, so wondering if it can be reused. If it can be used how has the experience been? ...
I'm writing a simple messaging program, where there is a table of messages, which can be claimed by users and have stuff done to them by that user. It isn't predestined which user will claim a given message and so I want a query to select the first of all the available messages, which I have, and then one to mark that message as take, wh...
I like ORM tools, but I have often thought that for large updates (thousands of rows), it seems inefficient to load, update and save when something like UPDATE [table] set [column] = [value] WHERE [predicate] would give much better performance. However, assuming one wanted to go down this route for performance reasons, how would you ...