database-migration

Is there a nice tool to convert gdbm file to sqlite database file?

Is there a nice tool to convert gdbm file to sqlite database file? ...

Does there exist a tool for DB schema migration where schema are specified using Hibernate ?

I am used to Django South http://south.aeracode.org/, which allows schema and data migrations for Django projects. Does there exist a similar tool for Hibernate projects ? ...

Experimenting with data to determine value - migration/methods?

Hey guys, I have a LOT of data available to me, and want to capture and experiment with data that isn't currently being used in production. I do not want to immediately add this to my existing data store since that would undoubtedly mess with production. The obvious solution seems to be to make a copy of production data and integrate it...

Database migrations with Qt4 (schema changes)

From Ruby on Rails I've learned about a comfortable and very manageable way to do database migrations. How would one handle such cases in Qt4? It does not need to be that elaborated as Rails' solution. I'd be fine with running SQL and code snippets to go up or down the version list of my data. I googled a little bit but there seems to ...

Move schema_migration table to newer version without migrating?

Most of my migrations are by number, not timestamp, but 5 or 6 of them (the most recent) are with timestamp. These I want to move to number based, and now I want to forward the migration table to the appropriate number. How do I force the table to update without actually running the migration, or should I migrate down to 5 or 6 ago (befo...

Help with Estimating a Data Migration

Our client has a completely custom CMS that was built in ASP 1.1 and later upgraded to 2.0. The database has over 200 tables, and unfortunately, there's no documentation for either the ASP code or the database. The original developers are unavailable for questioning, and no one at my company is familiar with the setup. The majority of t...

Creating a New Database from Within a Stored Procedure

Due to an employee quitting, I've been given a project that is outside my area of expertise. I have a product where each customer will have their own copy of a database. The UI for creating the database (licensing, basic info collection, etc) is being outsourced, so I was hoping to just have a single stored procedure they can call, p...

How to migrate SQL Server 2008 to MySQL 5.0 programmaticaly? {Closed}

How to migrate sql server 2008 to my sql 5.0 programmatically? any link? EDit:- Sorry for not asking question properly,See we will be getting sql server backup from client every night,and we have to load it to my sql every night.so we my solution is t0 try transtional replication.so i am trying heterogenous subscriber as my sql and prov...

Is there a good way to verify if a database schema is correct after an upgrade or migration?

We have customers who are upgrading from one database version to another (Oracle 9i to Oracle 10g or 11g to be specific). In one case, a customer exported the old database and imported it into the new one, but for some reason the indexes and constraints didn't get created. They may have done this on purpose to speed up the import process...

Best way to migrate a MySQL table with dupes to another table with a UNIQUE constraint

I am trying to work out the best approach for a data migration. I am migrating some data (~8000 rows) from a table like this: CREATE TABLE location ( location_id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY, addr VARCHAR(1000) NOT NULL, longitude FLOAT(11), latitude FLOAT(11) ) Engine = InnoDB, DEFAULT CHARSET=UTF8; ...

Handling change in a database schema

I am in the fairly initial stages of building an app which will hopefully be sold in the 1000's - more likely it'll be hundreds, but either way more than enough to cause a good sized headache for database schema changes. I'm rather restricted to a windows / .net / sql server environment as a number of our customers will be self hosting ...

Move Sql server 2005 to Oracle?

I want to move my SQL Server 2005 database to Oracle. How can I do that? What are the step I want to follow? Are there any tools for this? ...

For Ruby on Rails, how do you switch to a new and empty DB with the same DBMS or a different DBMS?

If no need to migrate the data, it seems that we can just edit database.yml development: adapter: mysql database: myapp_development host: localhost username: root password: encoding: utf8 1) to use a brand new db with 0 data, just change the 3rd line to: database: myapp_development_02 and then do a rake db:create and ra...

Usefulness of db migrations rollback

Hi, Many people talking about db migrations, especially about its rollback possibility. I doubt, whether it is useful at all, because schema of db and model are tightly connected with application logic (MVC). Suppose i've done rollback of some migration. And what ? The application will not work, because its logic fully relies on db. ...

Data migration from MySQL to HSQL

I was working on migrating data from MYSQL to HSQL. In MYSQL data file, there are plenty of records where date values are set as '0000-00-00' and HSQL database throws below error "data exception: invalid datetime format / Error Code: -3407 / State: 22007" for all such records. I would like to know what could be optimum solution for t...

SQL Server: What is the best way to Data Migration?

Hi All, I want to migrate data from one database to another database in Microsoft SQL Server 2005. I need to verify those rows retrieved before I insert them to the destination database's tables. Which approach is reasonable for this kind of things? I am trying to use two datasets in my VB.NET program. Is it reasonable? Can you sugges...

Can I change my migrations depending on the database adapter? How will it reflects in the schema.rb?

Specifically, I want to add an spatial index in a multi_polygon column. This works nicely in PostgreSQL but not in MySQL, so I was thinking of somthing like: create_table :figures do |t| t.multi_polygon :polygon end add_index :figures, :polygon if database_adapter == :postgresql Is it possible and a good idea? ...