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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 MySQL to SQL Server 2005

Author  Topic 

ann
Posting Yak Master

220 Posts

Posted - 2007-04-26 : 19:02:25
I've been asked to migrate a db in MySQL to SQL Server 2005. Since I'm only familiar with sql server 2000 and before, I dont' know where to begin looking for the information I need.
Can someone point me to what I would search for in SQL Server 05 for this (is there any new features here I should be aware of that might make this easier?)
If anyone has done this, what are the gotcha's or things I should be aware of.
Thanks for any input

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-26 : 19:08:27
Everything that is true for SQL Server 2000, is also true for SQL Server 2005.
SQL 2005 is backwards compatible.

Tables can be copied almost straight over.
Queries might need a check.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -