Migrating from MySQL to SQL Server

[Matthew Woodward]

Most of the time I've been tasked with going the opposite direction  
(from SQL Server to MySQL), but I'm moving my blog from a dedicated  
server to a shared hosting account at HostMySite (I just wasn't using  
the dedicated server nearly to its potential) so I'm moving from  
MySQL to SQL Server.  MS of course has a handy article helping with  
this migration, but the principles actually apply if you're going the  
other direction as well.

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx
Bottom line is that using the ODBC connection for MySQL and SQL  
Server's DTS capabilities are the simplest way to do this because the  
drivers handle a lot of the datatype mappings for you.  All I had to  
do when I just moved my database was tweak some varchar field lengths  
it read incorrectly and add the primary key after the import was  
complete.

Just thought I'd pass this along since we'd been discussing MySQL  
recently.

Matt
--
Matthew Woodward
[EMAIL PROTECTED]
----------------------------------------------------------
To post, send email to list@dfwcfug.org
To unsubscribe: 
  http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: 
  http://www.dfwcfug.org/form_MemberRegistration.cfm