November 6, 2008 at 9:38 pm
Hi ,
I have a doubt. My company database is in MYSQL.
Now we want to switch all data into SQL Server 2008.
I am not getting any answer that how will I convert this?
I can do this but that a long procedure (First create table exactly same as in MYSQL then by ssis or dts we can do this)
CAn you help me or tell me any other method?
Waiting for your reply.
Thanks
Shailesh
November 7, 2008 at 6:43 am
I'm pretty sure you've already answered your own question. Create the structures in SQL Server 2008 and then use an ETL tool (like SSIS) to pump the data across.
What's wrong with this approach? Yes, it's work and it's certainly harder than simply running a restore, but it's not exactly rocket science. It's just a bit of a hard slog. It shouldn't even be that bad since SSIS can shoulder a pretty substantial portion of the load for you.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 7, 2008 at 6:53 am
As stated above, the best approach would be to do this manually using ssis, I am not sure i would fully trust an automated tool to do this correctly.
Also since you are moving to 2008, which is a far superior system (imo), you may want to re-work your tables and procedures to take advantage of all the new features of 2008
November 7, 2008 at 7:25 am
If you only have tables, the conversion is pretty easy. Do just what you have said - create the schema and use an ETL tool to transfer the data. I would recommend creating FK relationships after you move the data.
There are data type differences, but you should be able to figure them out pretty easily.
If you have triggers, procedures, etc. in the MySQL database there are syntax differences and major differences in what will perform well (MySQL is cursor-based so loops work well - MSSQL is the opposite). If you have a lot of code to translate, the conversion will get pretty complex and you may want to bring in an expert that understands how to do these kinds of conversions.
November 7, 2008 at 10:34 am
Hi Shailesh,
There is a "Guide to Migrating from MySQL to SQL Server 2005" you can download (nothing for 2008 out yet):
There are tools out there for MySQL to 2000 and I believe also to 2005 but I haven't seen any for 2008 yet.
HTH!
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 7, 2008 at 8:59 pm
Hi,
Thanks to all of you. Even I believe that SSIS is the only reliable tool for doing this conversion.I got a tool for conversion
http://www.spectralcore.com/dl.php?reqfile=trial-fc-ent
From this tool we are able to convert but we are loosing some records.
Thanks again
Shailesh :):)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply