I have an existing Windows DB2 database that I'd like to move onto PostgreSQL. The users for the application can live with a weekend's worth of downtime. What's the best way to do that?
Investing in proper database design is a very efficient way to cut maintenance costs. If we expect a system to last, we need to make sure it has a good solid foundation - high quality database design. Surely we can and sometimes do cut corners and save on database design to get things done faster. Unfortunately, such cutting corners frequently…
Most projects now need some form of a database. When someone says database, I usually think relational databases, but I still hear about flat file XML databases.
What parameters do you take into consideration when deciding between a "real" database and a flat-file XML database.…
hi
i use sqlite database on my iphone app and
i need to update this database from the internet from my server
how i can download the new database and delete the old database
and recopy the new database to document directory
hi
i use sqlite database on my iphone app and
i need to update this database from the internet from my server
how i can download the new database and delete the old database
and recopy the new database to document directory
We're trying to export some tables from our production database to our test database using bcp. The bcp export seems to work fine, but the import always fails with a data type error (see below).
We tested on our test database exporting the table content to a file, then importing…
For some reason I can't get DTA to connect to my development machine. It connects to a remote DB just fine but when I point it to my dev machine I get an error saying:
Failed to initialize MSDB database for tuning (exit code: -1073741819).
I'm pretty sure it's not a permissions…
I have a web app that is currently live. I had the need to make major modifications to the database and now I need to replace the current one.
My dev SQL instance is not the live one. I usually just make a backup of the new DB, blow the old one away and Restore my updated one.…
Hi there,
This is the first time I'm approaching an extremely high-volume situation. This is an ad server based on MySQL. However, the query that is used incorporates a lot of JOINs and is generally just slow. (This is Rails ActiveRecord, btw)
sel = Ads.find(:all, :select =…
I have a save button in the activity where the user enters data which does this:
String subjectName = etName.getText().toString();
String subjectColour = etColour.getText().toString();
SQLDatabase entrySubject = new SQLDatabase(AddSubject.this);
entrySubject.open();…
It is pretty much very common to have a sample database for any database product. Different companies keep on improving their product and keep on coming up with innovation in their product. To demonstrate the capability of their new enhancements they need the sample…
This question came up today and I couldn't find any historical answer as to why a database is always represented as a cylinder. I am hoping someone in the stack world would know why and have a link or something backing it up.
In my opinion, if there's any reason to upgrade an E-Business Suite environment to the 11gR1 or 11gR2 database, it's the Advanced Compression database option. Oracle Advanced Compression was introduced in Oracle Database 11g, and allows you to compress…
Our application uses database (mostly Oracle), and database is at the core. Each customer has its own database, with its own copy of application. Now with each new release of our product, we also need to update the database schema. These changes are adding…
There is an interesting interview with Werner Vogels which is partly about how Amazon does Service Oriented Architecture:
For us service orientation means encapsulating the data with the
business logic that operates on the data, with the only access…
So my friend and I got briliant ;) idea for a business.
Since it is not predictable whether it will work out or not, we decided to keep cost as low as possible to start with, in particular not to hire anyone.
If it will work out as expected it will…
A few days ago I read a reply to a question where people said that the days of writing queries within your c# code are long gone.
I'm not sure what the specific person meant with the comment but it got me thinking. At the company I'm currently…
This is basically a question about what are weak entities? When should we use them? How should they be modeled?
What is the main difference between normal entities and weak entities? Does weak entities correspond to value objects when doing…
Consider an environment where we have a single, core database, with many separate systems using this one database.
This leads to all of these systems have a common dependency, which ultimately introduces coupling between them.
This…
I've been reading: https://help.ubuntu.com/community/UbuntuCloudInfrastructure
It's fascinating stuff, but documentation seems a bit sparse. Where I work, we have this aging, clunky VMWare ESXi setup for all our internal servers. I'd…
I only recently learned that there is a huge pile of documentation in /usr/share/doc.
How on earth is a typical user supposed to find out about that?
It seems like much of it is gzipped, and inaccessible with administrative…
I've been trying to see if I can accomplish some requirements with a document based database, in this case CouchDB. Two generic requirements:
CRUD of entities with some fields which have unique index on it
ecommerce…
Hi there,
I am coding in ASP.NET C#.
I have Microsoft Dynamics GP hosted at a server and my database hosted at another server.
I would like the GP database take value from some table there and synchronise it with my…
I have an internal SQL Server 2005 database "ADMIN_DATA" that is used by admin users.
We would like to sync three of the database tables in ADMIN_DATA out to another SQL Server 2005 database "WEB_DATA", which is…