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 |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2005-12-03 : 14:08:06
|
| I've got a medium sized table (25k rows) in mysql that's getting hit hard by linked server queries on the mssql side. It's just for reporting, and exact accuracy is not important. The obvious answer seems to be to periodically copy the table to mssql, where the sp's that are hitting it will make things a lot faster.However, mysql has all sorts of datatype differences from mssql. I could go through and do this manually, but 1) the table has a lot of columns, and 2) if this works I expect to do it on other tables as well.Does anyone know an automated tool that I can point at a mysql table and get a corresponding mssql create table statement?Thanks-b |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-12-03 : 14:54:48
|
| the datatypes aren't that different.you can accomplish this a bunch of ways, here are a couple of easy methods:1. use the mysqldump command to dump the contents of the table to a text file. This can include both DDL and DML. Edit this file and modify the datatypes on the create table command to match SQL Server.2. Use DTS to import to SQL server.here is a Microsoft whitepaper on migrating from mysql to SQL Server http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx-ec |
 |
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2005-12-03 : 18:00:23
|
| Thanks for the hint; I hadn't realized DTS made it so easy. This will be a recurring job, so that was the way to go.Cheers-b |
|
|
|
|
|
|
Copying tables from MySQL?