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 |
|
flower
Starting Member
3 Posts |
 Posted - 2006-02-10 : 12:50:15
|
| Hi evrybody,I have been trying to migrate MY SQL to MSSQL and somehow cant do it.I tried making Dsn for both of them, but the DTS wizard doesnt recognize MYSQL .DOes anybody knwo how to do this?thanks |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-10 : 13:00:28
|
| Can you connect to MySQL using ODBC? you may be able to do it through that.steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
 |
|
|
flower
Starting Member
3 Posts |
Posted - 2006-02-10 : 13:55:52
|
I was able to connect to MYSql using ODBC using system DSN.but wht ahead? The MS SQL 2005 server DTS doesnt shw the MYSQL in the dropdown for data sources.Thanksquote:
Originally posted by elwoos
Can you connect to MySQL using ODBC? you may be able to do it through that.steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true!
|
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-13 : 03:24:34
|
| Hmm not sure about 2005 but in 2000 you have "Other Connection" and you should be able to use that with your DSNsteve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
|
|
|
migration