PHISSUG

Hi, guys! I've got this migration project from MS SQL 6.5 to MySQL. Anyone who has tried it? I'm currently seeking for the best way to do the migration process. Any issues that I need to expect? Thanks.

---

Cherrie Ann B. Domingo
Jr. Systems Analyst/Programmer

E-mail: cherrie.ann.domingo@gmail.com
Blog: http://thinkingmnemosyne.blogspot.com
Website: http://www.c2-synthesis.com, http://www.cherrieanndomingo.com

betelguese:

Hi, guys! I've got this migration project from MS SQL 6.5 to MySQL. Anyone who has tried it? I'm currently seeking for the best way to do the migration process. Any issues that I need to expect? Thanks.

sana pabaliktad heheh. MySQL > MsSQL. I am not familiar with MySQL but you can extract out the data to CSV or text and import it to any database out there. It should be pretty easy to do. and vice versa :)

ggsubscribe:

betelguese:

Hi, guys! I've got this migration project from MS SQL 6.5 to MySQL. Anyone who has tried it? I'm currently seeking for the best way to do the migration process. Any issues that I need to expect? Thanks.

sana pabaliktad heheh. MySQL > MsSQL. I am not familiar with MySQL but you can extract out the data to CSV or text and import it to any database out there. It should be pretty easy to do. and vice versa :)

 

sir gg, next time, pabaliktad po, ehehe... = P sideline project lng nman po. thanks po for the recommendation. 

---

Cherrie Ann B. Domingo
Jr. Systems Analyst/Programmer

E-mail: cherrie.ann.domingo@gmail.com
Blog: http://thinkingmnemosyne.blogspot.com
Website: http://www.c2-synthesis.com, http://www.cherrieanndomingo.com

Just remember to take note of the primary key-foreigh key constraints when migrating your data.  How many tables do you have?

---

Check out SQL Server tips at http://www.mssqltips.com
Check out SQL Server 2008 videos at
http://blogcastrepository.com

bass_player:

Just remember to take note of the primary key-foreigh key constraints when migrating your data.  How many tables do you have?

 Sir, di pa po napapakita sa akin eh. All i know as of now po is that 4GB of data po yung i-mimigrate. I'll update you po as soon as I have talked again with the client. Thank you for your advices. ^_^
 

---

Cherrie Ann B. Domingo
Jr. Systems Analyst/Programmer

E-mail: cherrie.ann.domingo@gmail.com
Blog: http://thinkingmnemosyne.blogspot.com
Website: http://www.c2-synthesis.com, http://www.cherrieanndomingo.com

Updates:

According to them, the backup is in .DAT format. DAT file was extracted from HD of the production server. It's about 9 - 10 years old and contains sensitive data. They've just found out that the DB was corrupted which caused the troubles in opening the DAT file.

 I've done some research and found out that only MS SQL Server 6.5 could open that DAT file. Unfortunately, I might not be able to do the migration anymore due to schedule conflict with them. :'(

---

Cherrie Ann B. Domingo
Jr. Systems Analyst/Programmer

E-mail: cherrie.ann.domingo@gmail.com
Blog: http://thinkingmnemosyne.blogspot.com
Website: http://www.c2-synthesis.com, http://www.cherrieanndomingo.com

betelguese:

Updates:

According to them, the backup is in .DAT format. DAT file was extracted from HD of the production server. It's about 9 - 10 years old and contains sensitive data. They've just found out that the DB was corrupted which caused the troubles in opening the DAT file.

 I've done some research and found out that only MS SQL Server 6.5 could open that DAT file. Unfortunately, I might not be able to do the migration anymore due to schedule conflict with them. :'(

you can refer PHISSUG to them if you cant do it anymore. Am sure there are still SQL Server 6.5 installers hanging around somewhere :)

ggsubscribe:

betelguese:

Updates:

According to them, the backup is in .DAT format. DAT file was extracted from HD of the production server. It's about 9 - 10 years old and contains sensitive data. They've just found out that the DB was corrupted which caused the troubles in opening the DAT file.

 I've done some research and found out that only MS SQL Server 6.5 could open that DAT file. Unfortunately, I might not be able to do the migration anymore due to schedule conflict with them. :'(

you can refer PHISSUG to them if you cant do it anymore. Am sure there are still SQL Server 6.5 installers hanging around somewhere :)

i would tell the client po. ^_^ i think the installers are still available for MSDN subscribers.  

---

Cherrie Ann B. Domingo
Jr. Systems Analyst/Programmer

E-mail: cherrie.ann.domingo@gmail.com
Blog: http://thinkingmnemosyne.blogspot.com
Website: http://www.c2-synthesis.com, http://www.cherrieanndomingo.com

yes, SQL Server 6.5 is still downloadable in MSDN Subscription.

Thank you for bringing this up - betelguese.

We are looking for someone to help us migration existing MsSQL 6.5 database to MySQL. Anyone with relevant experience are free to apply, this is a part-time job but must be available during office hours and must stay in our office in Ortigas. Interested parties, please send resumes to allanctan@yahoo.com.

 Maraming Salamat po.

 

allanctan:

Thank you for bringing this up - betelguese.

We are looking for someone to help us migration existing MsSQL 6.5 database to MySQL. Anyone with relevant experience are free to apply, this is a part-time job but must be available during office hours and must stay in our office in Ortigas. Interested parties, please send resumes to allanctan@yahoo.com.

 Maraming Salamat po.

 

No problem, Allan. ^_^ Cherrie here. We surely want to be of help.

Guys, Allan is the client of this project. For interested parties, please do send your resume to his e-mail.
 

---

Cherrie Ann B. Domingo
Jr. Systems Analyst/Programmer

E-mail: cherrie.ann.domingo@gmail.com
Blog: http://thinkingmnemosyne.blogspot.com
Website: http://www.c2-synthesis.com, http://www.cherrieanndomingo.com

Guys, how do you restore .DAT backup file in SQL Server 6.5?

---

Cherrie Ann B. Domingo
Jr. Systems Analyst/Programmer

E-mail: cherrie.ann.domingo@gmail.com
Blog: http://thinkingmnemosyne.blogspot.com
Website: http://www.c2-synthesis.com, http://www.cherrieanndomingo.com

Sorry chean, I cant asnwer accurately anymore on this. I got no 6.5 environment anymore and it would be hard to still provide you with asnwers (not unless anyone out there is still supporting a 6.5 database in production). I have to set it u for you to be able to give you a direct asnwer [:P].

Just in case, you can't resolve this and you want to really migrate a 6.5 DB, i'll take this on a formal consulting engagement. but of course, you got to give it a try first.

ggsubscribe:

Sorry chean, I cant asnwer accurately anymore on this. I got no 6.5 environment anymore and it would be hard to still provide you with asnwers (not unless anyone out there is still supporting a 6.5 database in production). I have to set it u for you to be able to give you a direct asnwer [:P].

Just in case, you can't resolve this and you want to really migrate a 6.5 DB, i'll take this on a formal consulting engagement. but of course, you got to give it a try first.

 tnx, sir gg. ^_^ i understand po. i'll give my best.

---

Cherrie Ann B. Domingo
Jr. Systems Analyst/Programmer

E-mail: cherrie.ann.domingo@gmail.com
Blog: http://thinkingmnemosyne.blogspot.com
Website: http://www.c2-synthesis.com, http://www.cherrieanndomingo.com

hi chean,

have you checked the documentation included in the installer? thats your only hope, wala n kc documentation for sql 6.5 available s internet.