LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices


Reply
  Search this Thread
Old 08-31-2008, 11:18 PM   #1
jiml8
Senior Member
 
Registered: Sep 2003
Posts: 3,171

Rep: Reputation: 116Reputation: 116
migrating a database is such a PITA


I just thought I'd throw that in.

I just completed migrating a Superbase database to mysql. Only took 26 hours, and three programs (one in superbase to export all the tables as a modified csv, and two C++ programs - one to read and translate the superbase structure into mysql structure, and one to actually build the mysql import file) to handle the move. This was data and indexes only; no stored procedures were moved.

Next I intend to move it to MS SQL and probably to Oracle too. I do hope that those moves are easier since I have working mysql code.
 
Old 08-31-2008, 11:40 PM   #2
pinniped
Senior Member
 
Registered: May 2008
Location: planet earth
Distribution: Debian
Posts: 1,732

Rep: Reputation: 50
Couldn't Superbase export as a series of SQL commands? That would just leave you with the not-so-compatible bits to deal with.

Have fun.
 
Old 09-01-2008, 12:15 AM   #3
jiml8
Senior Member
 
Registered: Sep 2003
Posts: 3,171

Original Poster
Rep: Reputation: 116Reputation: 116
Superbase is supposed to export to one of a few different sqls, but I seem to not have the relevant dlls, and mysql (and for that matter MS sql) are not on the list.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Migrating the NIS database into fedora DS ?? ajeetraina LinuxAnswers Discussion 0 09-22-2007 09:21 AM
Migrating NIS Database to Fedora DS?? ajeetraina Linux - Server 0 09-18-2007 12:42 AM
LInux printing - PITA xanas3712 Linux - Hardware 1 05-13-2006 11:37 AM
Is K3B always such a PITA ??? bigjohn Linux - Software 5 08-20-2005 01:34 PM
bind is a pita.... trey85stang Linux - Networking 2 07-14-2004 07:28 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > General

All times are GMT -5. The time now is 10:47 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration