Jump to content

phpMyAdmin equivalent?


matfish

Recommended Posts

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

Link to comment
Share on other sites

  • 4 weeks later...

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 1 month later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.