Re: Migrating from MySQL to SQL Server

[Matthew Woodward]

Can you point me in the right direction on that again?  Once I get  
done with my master's in July or August I want to look into teaching  
some classes at one of the community colleges around here.  You know  
me, I love to talk at people. ;-)

On May 5, 2005, at 8:48 AM, Clement Cervenka wrote:
Matt,
    In regards to your posting comments, have you
throught about posting that introduction overview
seminar offer at Dallas Lake View campus covering
linux, apache, mysql, pearl email I forwarded me
recently. This seminar is just an general overview
of these 4 programs.
Joe Cervenka
--- Matthew Woodward <[EMAIL PROTECTED]> wrote:
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



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
----------------------------------------------------------
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

--
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