how can I transfer my SQl databese (located on PHPADMIN) to sql server?

Recommended Answers

All 5 Replies

Export to a CSV and import into SQL SERVER.

Some Database Converters are alse available....You can use....

or you can export in csv format from mysql table and import in mssql table.

If you are moving from MySQL to SQLServer than the "Microsoft SQL Server Migration Assistent" is a nice tool.

thank you for your reply.. i will try.

how can I transfer my SQl databese (located on PHPADMIN) to sql server?

You could try using the SQL Server Migration Assistant for MySQL. If you want to migrate to a SQL Server 2005, the download is here: http://www.microsoft.com/downloads/details.aspx?FamilyID=c6f14640-da22-4604-aaaa-a45de4a0cd4a&displaylang=en
If you want to migrate to SQL Server 2008, the download is here: http://www.microsoft.com/downloads/details.aspx?FamilyID=0e6168b0-2d0c-4076-96c2-60bd25294a8e&displaylang=en

Hope that helps.
-Brian

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.