Databases, Database migration
   |
| Sn_ake |
 Aug 10 2004, 03:53 PM
Post
#1
|
|
nFm [ not leaving ]  Group: Full Member Posts: 58 Joined: 20-June 04 Member No.: 120  |
Hi there peps wondering if some one out there might have some experience with migration of databases.
Basicly here at work we need to migrate a anywhere SQL data base of about 200 megs in size over to a MS SQL database. Now after having a little look around i noticed that there is software out there that will take care of this. What i'm wondering is if anyone out there has undergone a similar procedure and if so how was it. |
   |
 
|
| DutchKid |
Aug 10 2004, 04:51 PM
Post
#2
|
|
Institutionalised Nutcase Group: Admin Posts: 576 Joined: 17-March 04 From: The Netherlands Member No.: 6 |
I've never done such a thing, but I can imagine that it'll take quite long!
-------------------- .gif) -----------------------Live The Day At Hand----------------------- |
|
|
|
| Saint26 |
Aug 10 2004, 05:41 PM
Post
#3
|
 nFm [ progressor ] Group: Private Member Posts: 186 Joined: 18-March 04 Member No.: 31 |
Actually, 200mb is nothing. It shouldn't take long at all.
As long as you match the database structure on both sides, a simple simple odbc connection should do the job for you. If not, you may want to try to do it the longer way which would be to go from MySQL to MS Access (tons of tools out there to do this) and then go from MS Access to MS SQL (Direct upgrade wizard available for this). --------------------  |
|
|
|
| Sn_ake |
Aug 10 2004, 10:12 PM
Post
#4
|
|
nFm [ not leaving ] Group: Full Member Posts: 58 Joined: 20-June 04 Member No.: 120 |
Managed to convert the databases with ease with a nice little tool that migrated it all in the end. Now what i'm after however is a tool which will create data entity diagrams representing the DB. Seems that there are a lot of proggys that will go from erd to db but not many the other way around.
|
|
|
|
| Saint26 |
Aug 11 2004, 02:43 PM
Post
#5
|
|
nFm [ progressor ] Group: Private Member Posts: 186 Joined: 18-March 04 Member No.: 31 |
Nothing beter than ER-Studio for the job. Will create the diagrams for you and then some. Alco check out some of the other products made by Embarcadero. They make some sweet tools.
hXXp://www.embarcadero.com/products/erstudio/ -------------------- |
|
|
|
| Sn_ake |
Aug 12 2004, 05:40 PM
Post
#6
|
|
nFm [ not leaving ] Group: Full Member Posts: 58 Joined: 20-June 04 Member No.: 120 |
Cheers for the link.
Thankfully the data base migration is off my hands now, and the finall touchs will be taken care of by some one else :D . |
|
|
|
 |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 1st July 2025 - 10:10 PM |
Powered by Invision Power Board(Trial) v2.0.0 © 2025 IPS, Inc.