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. |
   |
 
|
   |
Replies
| Saint26 |
Aug 10 2004, 05:41 PM
Post
#2
|
 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). --------------------  |
|
|
|
Posts in this topic
Sn_ake Databases Aug 10 2004, 03:53 PM
DutchKid I've never done such a thing, but I can imagin... Aug 10 2004, 04:51 PM Sn_ake Managed to convert the databases with ease with a ... Aug 10 2004, 10:12 PM Saint26 Nothing beter than ER-Studio for the job. Will cre... Aug 11 2004, 02:43 PM
Sn_ake Cheers for the link.
Thankfully the data base mig... Aug 12 2004, 05:40 PM |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 2nd July 2025 - 06:32 AM |
Powered by Invision Power Board(Trial) v2.0.0 © 2025 IPS, Inc.