September 8, 2010 at 4:51 am
We have an application which was originally installed with a MySQL format. We are now nearly completely SQL Server (of various types). This supplier now has sent an update but it is in a MySQL format. They say that if we want it in SQL Server we will have to convert it.
Never tried this before.............has any one any experience?
Madame Artois
September 8, 2010 at 4:59 am
Update in the sense??
If its data and both SQL & MySQL have same structure its easy..Can you please be more specific on your requirement??
September 8, 2010 at 6:55 am
No they don't have the same structure. MySQL uses files whilst SQL Server uses tables
Madame Artois
September 8, 2010 at 7:00 am
Not knowing exactly what you need, this might be off, but what about loading the update into a MySql instance and then using SSIS to migrate the data?
If it's structures or code, you'll just have to rebuild it manually. There's no way to move it automatically that I'm aware of.
"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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply