Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jej1216
Starting Member
27 Posts |
 Posted - 2008-02-14 : 13:57:28
|
| I am not a DBA, so forgive this question.I have a small DB (8MB) that I need to recreate as a MySQL DB. In Enterprise Manager, I can only see how to export the data per table to a text file. Is there a way to export the entire DB data and structure to a text file? I have looked in the Microsoft Management Console help and can't find anything there that looks like what I need. We are a small company and have no DBA on staff, so I'm left to my own devices to figure out admin tasks.TIA,jej1216 |
|
|
MuadDBA
628 Posts |
Posted - 2008-02-15 : 11:35:18
|
| I hope I'm not going to come off too badly here, but I think your company is taking the wrong direction. Moving data out of SQL server and into MySQL is setting yourself up for problems. Unless you're an exremely competent programmer who enjoys putting all of the validations (and I mean all of them) in your code as opposed to your database engine, I wouldn't recommend this switch.Sounds to me like you're doing this for cost reasons, but please step back and make sure that you're taking everythign into account.AS far as exporting the structures, you can script them, but they are going to be specific to Microsoft's implementation of SQL Server and not likely to work with MySQL without plenty of tweaking.There is no real way to export all of the data and structure out of the database in one text file that I know of. |
 |
|
|
jej1216
Starting Member
27 Posts |
Posted - 2008-02-15 : 15:18:32
|
| Your points are all well taken - but I'm not a big gun. I just got the task assigned to me.The DB in question is very small and we need to migrate it to MySQL for consistency - all of our other internal company apps run off of MySQL. I can manually build the tables and then transfer the data in about one full day. I was just hoping there might be some simple way to do this that I was unaware of.Thanks |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-16 : 07:14:45
|
| I agree with crazyjoe , but if you have to : check DTS and also , MSSQL2MYSQLJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-02-16 : 07:58:29
|
I'm pretty sure that mysql comes with a "migration wizard" type GUI app for just this purpose.
elsasoft.org |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-16 : 14:02:25
|
| If you have SQL Server 2005 then you can use Copy Database task in SSIS for copying tables |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 14:37:36
|
| Is it mssql or mysql issue? |
|
|
|
|
|
|
|
|
Need to export both data and structure to a file.