dbTalk Databases Forums  

Import Tables from MySQL to SQL Server 2005

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Import Tables from MySQL to SQL Server 2005 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default Import Tables from MySQL to SQL Server 2005 - 05-23-2006 , 09:00 AM






Hi all,

I have the following situation: I want to import a MySQL Database into
a SQL Server 2005 database. I have the structures yet created in the
SQL Server database. So now I am doing an import table by table. It is
all the time the same cause my SQL-command is always "select * from
....".

I was asking me, isn't there a way to do that more easy than by hand?

Greetings Daniel


Reply With Quote
  #2  
Old   
satish
 
Posts: n/a

Default Re: Import Tables from MySQL to SQL Server 2005 - 05-24-2006 , 08:32 AM






dear daniel,
i would like to know -- whether the database file is in which format
i mean -- flat source file, notepad file or raw file -- can u pls
define me the structure of ur MS Sql database --

satish


Reply With Quote
  #3  
Old   
AT
 
Posts: n/a

Default Re: Import Tables from MySQL to SQL Server 2005 - 05-24-2006 , 09:31 AM



I use an ODBC Driver for the MySQL DB!
Does this help?

Daniel


Reply With Quote
  #4  
Old   
AT
 
Posts: n/a

Default Re: Import Tables from MySQL to SQL Server 2005 - 05-24-2006 , 09:31 AM



I use an ODBC Driver for the MySQL DB!
Does this help?

Daniel


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.