How to shift My Sql data to Sql Server
-
Hi,I have a small problem,first we used MySql as a database,The database contain realworld data,suddenly we have need to shift database to Sql Server Is their any way to avoid refill data manually in SqlServer. Plz,Help me in Solving the problem Advanced Thanks, Srilakshmi
-
Hi,I have a small problem,first we used MySql as a database,The database contain realworld data,suddenly we have need to shift database to Sql Server Is their any way to avoid refill data manually in SqlServer. Plz,Help me in Solving the problem Advanced Thanks, Srilakshmi
You can use Enterprise Manager (if you have SQL 2000), or SQL Server Management Studio (if you have SQL 2005) to import your data (tables, columns, records) from MySQL. The wizard to do import/export data should be simple enough to follow.
"A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin Edbert Sydney, Australia