breeze351
asked on
SQL Server Express
IS SQL Server Express just a data base server or are there tools that would allow you to set up ad-hoc querys, something like Access? I've never used it and now I have a possible client that asked about this.
Jeff gave you good info. However, SQL Server Express is strictly a Windows product. It is a little more difficult to setup than MySQL is and there are some differences in coding required. I have it installed on 3 computers here and on my Windows hosting on Godaddy.
Dave, I read that as asking if SQL Server Express had tools like Access for building ad-hoc queries, rather than "are there other tools out there that are like Access, besides SQL Server Express" and assumed the need for a Windows environment, based on the mention of two Windows-specific products (SQL Server and Access).
I agree that MySQL is another alternative, as is PostgreSQL, both of which can be installed on non-Windows environments and both are similar to SQL Server Express in that they are inexpensive or free and both are designed more as database servers, with separate tools (such as MySQL Workbench) for graphical management of the databases and development of ad-hoc queries.
I agree that MySQL is another alternative, as is PostgreSQL, both of which can be installed on non-Windows environments and both are similar to SQL Server Express in that they are inexpensive or free and both are designed more as database servers, with separate tools (such as MySQL Workbench) for graphical management of the databases and development of ad-hoc queries.
Most of breeze351's questions have been about MySQL and PHP. That's why I answered that way.
take a look at this link, it will show you the difference between SQL Server and SQL express: http://www.sqlmvp.org/diff
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All these answers are helpful and I will select all as solutions. Now all I need to do is print them out. How do I do this?
Do you want to print our comments?
I think any browser has a Print option. Another option is to copy all the comments to a text file or a Word document.
I think any browser has a Print option. Another option is to copy all the comments to a text file or a Word document.
ASKER
Yes I want to print the comments. I tried that. I'm using Firefox as the browser. All I get is the stuff on the right and no comments!
I'm using IE and can print the comments. I don't have Firefox to test it but you should then contact EE's support with your issue. They may be able to help you better.
There is a comparison of the different SQL Server editions, including express, herehere.
You can likewise download SQL Server Management Studio (SSMS) for free here.
Access is kind of an all-in-one package where you create an application which combines a database with the queries and forms as a single file which can then be used by other people who have Access installed. SQL Server Express is designed to hold multiple databases. Although you can use SSMS to create queries and manage the databases, if you need to create forms for accessing the database you'd likely do that with something like Visual Basic or another programming language. You can also combine the two - if you need a more robust database than Access provides, but you want the query and form building tools in Access, you can create an Access application that acts as the 'front end' and points to tables on the SQL Express 'back end'.