matfish Posted March 18, 2010 Share Posted March 18, 2010 Hi there, I'm a PHP/MySQL developer and not touched ASP/MSSQL once! I'm trying to help someone out and needed to know if there was an equivalent way to connect to an MSSQL database and export all tables to .CSV (as I would usually do in phpMyAdmin) I've Googled and found "SQL SERVER EXPRESS" - is this easy enough to do the trick? Many thanks Quote Link to comment https://forums.phpfreaks.com/topic/195742-phpmyadmin-equivalent/ Share on other sites More sharing options...
roopurt18 Posted April 9, 2010 Share Posted April 9, 2010 I'm not a Microsoft guy so take this with a grain of salt. SQL Server Express is like a toned down version of SQL Server 2005|2008, sort of like how MS has Visual C# Express and Visual Basic Express. Essentially MS is creating freeware versions of their IDEs and technologies in hopes of competing with open source. So you are probably not interested in SQL Server Express as it sounds like the MS SQL database already exists. What you probably want is SQL Server Management Studio Express. You might also want to read up on Microsoft's BCP program, which is suited for importing or exporting bulk data in and out of SQL Server. Quote Link to comment https://forums.phpfreaks.com/topic/195742-phpmyadmin-equivalent/#findComment-1039823 Share on other sites More sharing options...
andrewgauger Posted April 11, 2010 Share Posted April 11, 2010 There is an import and export feature on the computer hosting the SQL SERVER (express or not) Go to start -> Microsoft SQL Server 2008 -> Export Data (32-bit | 64-bit) and follow the wizard. I think the same is true for 2005, but my version of 2005 was the one included with visual studio 2008 and I use MSSQL 2008 for the data. I do remember exporting data the same way with SQL 7.0 so I am sure if you get on the machine actually hosting the database, it will be easy. Quote Link to comment https://forums.phpfreaks.com/topic/195742-phpmyadmin-equivalent/#findComment-1039839 Share on other sites More sharing options...
Sudantha Posted May 16, 2010 Share Posted May 16, 2010 u can use Microsoft SQL Server Management Studio Express as a PHPmyAdmin equivalent http://www.en.wikipedia.org/wiki/SQL_Server_Management_Studio Download Link : http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en Quote Link to comment https://forums.phpfreaks.com/topic/195742-phpmyadmin-equivalent/#findComment-1059053 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.