How to move data from suppose mysql database to postgres database? Scenario: Two similar application. A user wants to switch from one application to other. But he had maintained certain data information in his previous appilaction which uses mysql database.When he switch his appliaction he has to move his data from his old application t...
Is it possible edit a table definition to automagically trim entries of all trailing whitespace when they are entered? Or would this be more efficient/easier/normally done in the code befeore submitting the entries?? ...
In the past when working with databases I've found it necessary to do low-level tweaks to the query, for example providing hints to the optimiser that it should use a particular index or join order. We are currently considering rewriting our data layer using Entity Framework; is it the case that using EF prevents this sort of low-level o...
A lot of Database schemas seem to follow the following standard: (2^n)-1 for large fields: varchar(511) varchar(255) varchar(127) ...then (2^n) for smaller ones varchar(64) varchar(32) varchar(16) varchar(8) I understand why numbers of (2^n)-1 are used, what I don't understand is why it is not necessary to continue the trend down ...
I am facing problem capturing Chinese characters in a dataset. In Delphi 2010 I have tried two kinds of components: Delphi default Developer Express components As result, those components that do not link to the datasource are working fine, but those components do that link to the datasource have a problem. The Chinese characters ha...
I have a SSIS package (exports some database tables --> CSV file) After creation of this package, I can run the package from Visual Studio or just by clicking it. But it fails if i add to execute this package as a SQL Agent Job scheduled at some arbitrary time of a day. Pointers needed if i have to configure anything related to Permi...
Is there a way that one can test if a row has been locked for update in Oracle? As an example, suppose the following query, performed by one user: select * from SOME_TABLE where THE_ID = 1000 for update; With another user I want to check if the row with THE_ID = 1000 is locked. If I try an update or something the second user gets blo...
I understand that the "Cannot sort a row of size 9754, which is greater than the allowable maximum of 8094." from SQL server is caused by a row that has over 9k characters in it, which is greater than the page size limit in SQL Server 7. But I'm not calling an order by on the data below, so why does the error say it cannot sort? SELECT...
Hi, I have found this answer useful: Accent and case insensitive COLLATE equivalent in Oracle, but my question is regarding LIKE searching with a version 9 Oracle db. I have tried a query like this: SELECT column_name FROM table_name WHERE NLSSORT(column_name, 'NLS_SORT = Latin_AI') LIKE NLSSORT('%somethingInDB%', 'NLS_SORT = Latin_AI...
I have a database project (.dbp) open in Visual Studio 2008 as part of a solution. I've added a new sql script to the project. When I try to save the database project so that I can check it in, VS shows me a dialog: Some Unicode characters in this file could not be saved. To save all the information in this file, use 'Save As'; and ...
ZenPack development seems to involve the creation of a variety of persistent state. There are model classes which represent explicitly persistent state. There are skins which are associated with model objects. There are organizers and instances of persistent classes (data sources, graphs, etc). Considering that during development, ma...
I've been tackling this for a while. I setup a completely new machine. I've installed a fresh copy of postgresql and all my other dependencies. Basically, I get these database disconnections at random times. I can perform identical requests and either it works or it doesn't. Very nondeterministic in outward appearance. Watching logs at P...
When trying to use DDLUtils it always seems to take over the id values for the columns that are set to autoincrement. How can I prevent this? For example, I have a Dogs table with a column called ownerID. The column ownerID is set to autoincrement. However my list of owners is not continuous, there are gaps (for example, ownerID's 2, 4,...
I was thinking of starting a project that very clearly needs a persistent store. I was about to reluctantly decide on a RDBMS, when I came across an article which briefly mentions CouchDB. Seems some advancements in DB technology have happened since I last looked, so I thought I would ask here about databases before I got into it. Here ...
Hi, My question is regarding referential integrity concept in MySQL Database. Due to some kind of restrictions from our DBA we are not allowed to use referential integrity features of MySQL and so my question is "How can we implement Foreign Key concept in MySQL when we do not have referential integrity features in MySQL ?" Thanks. ...
I've spent hours searching the web for an answer to this question... Here's what I currently have: select * from order_header oh where tran_date = sysdate-1 Thanks in advance. ...
I have a very little idea about what database file system is. Can somebody out here explain to me what actually a database file system is, and what its applications are? How is it different from a conventional file system? How I can build it? ...
Hi everibody, Have a good day. So my problem is basically this, I need to process 37.800.000 files. Each "file" is really more than that, what I have is: 37.800.000 XML documents. More than 120.000.000 of Tiff images. Each of the XML documents reference one or more Tiff images and provides a set of common keywords for the images it...
Hi Djangonauts, I am almost done developing a Django project (with a few pluggable apps). I want to offer this project as a SaaS (something like 37signals.com). i.e: customer1.product1.com , customer2.product2.com etc product1 could be the basecamp product2 could be highrise and so on. I want to know how the project should be struc...
Can somebody advise idea, how to match user input (few words) to appropriate tags in system (each of them also 1 or N words)? Here is sample to demonstrate problem: I have a Tags, assigned to objects. For example (tags are separated by COMA, but in real life I have relation to table) Object Tags Earth ...