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)
 Import SQL query into SQL Server management studio

Author  Topic 

hemil_sheth
Starting Member

1 Post

Posted - 2009-09-17 : 01:22:25
I have a SQL file which I have exported from phpmyAdmin and I want to import into SQL SERVER 2005 management studio, but due to syntax difference it gives me error. IS there any easy way that I can do this at once.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-09-17 : 03:56:57
I assume that this is from MySQL then? I know it's possible to export schema definitions from MySQL in "sql server friendly" format...I think it's mysqldump or something. If that doesn't work for you then search/replace is your friend...

- Lumbago
Go to Top of Page
   

- Advertisement -