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  General SQL Server Forums  New to SQL Server Administration  trying to import mssql to export for mysql

Author  Topic  oncol Starting Member 1 Post Posted - 2011-07-11 : 18:15:21 I'm "new" to mssql server administration, similar to the circumstance described here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139861 "with mysql i can dump a database with mysqldump in a text file .SQL and i can import a this dump file directly from mysql ..." All I need from mssql is to import an existing sql file, dumped from another mssql server, so I can export it into a format importable in mysql, with which I'm amply familiar. Trying to import to mssql, I've fallen down the rabbit hole. It starts here - a process I've tried repeatedly based on other instructions, which I find repeated in the thread linked above: "Install SQL server management studio 2005/08 Once configured, connect by providing authetication windows or sql" When I attempt to install SQL server management studio, I get error message "To continue one or more feature must be selected" I've tried to select either Instance features, Shared features or Redistributable features, but only Shared shows a checkbox, which is checked but the checkbox is grayed out. To be honest, I don't even know if I have SQL Server 2008 running. I'm running a Win7 Asus machine, and SQL server is part of the stock package. I installed WAMP, and don't know if that maybe disabled SQL Server 2008. Really, all I need to do is reformat this msSQL dump into language compatabile with MySQL. I have a lot of data analysis to do, and would rather not spend another day in the rabbit hole of exploring a server I don't even need. However, getting the agency to reformat their SQL dump is also out of the question. Suggestions?