1
vote
2answers
36 views

how to upgrade and migrate postgres dbs to new server machine?

my production databases run on a centos 5.5 virtual machine. This server has 2 postgres 8.4 clusters installed on 2 different partitions; now my idea is to upgrade both db version and server os ...
2
votes
2answers
32 views

Migrating data from a boolean column to a varchar column

My table currently has a boolean column, let's call it the "important" column, reflecting whether a record is urgent or not. I want to transition to using a varchar column that reflects a record's ...
8
votes
1answer
2k views

Upgrade SQL Server 2000 database to 2008 R2 and enable new features

I have recently upgraded SQL Server 2000 database to 2008 R2. What I did was: Shutdown SQL Server 2000 (express) service on old machine, Move datafiles (mydatabase.mdf and mydatabase.ldf) to new ...
0
votes
3answers
115 views

Database migration, how to

I have two databases DB1 and DB2. In both databases exists this two tables mo_sms and mt_sms. This is the structure of those tables: CREATE TABLE IF NOT EXISTS `mo_sms` ( `id_MO` int(11) unsigned ...
2
votes
2answers
329 views

Tool to export data with all relational data?

Is there a tool to export data from selected rows in a table with all data stored in other tables in other tables linked by relational design? The purpose is to ease migrations of bits of data ...