File Details |
|
File Size | 8.8 MB |
---|---|
License | Shareware |
Operating System | Windows 2000/9x/Server 2003/XP |
Date Added | March 17, 2004 |
Total Downloads | 2,372 |
Publisher | Speciality Applications |
Homepage | mssqlXpress |
Publisher's Description
mssqlXpress delivers to the developer a tool that combines the best features of Enterprise Manager and Query Analyzer with even more features. Ability to retain history of all changes to stored procs, triggers, and databases. MDI interface to enable the easy copying and pasting of code between objects. Script generation with them been stored to a database for easy retrival.
Latest Reviews
mrgrieves reviewed v1.2.9.5 on Mar 17, 2004
(For 1.3.0.6) - this application just keeps improving. The XML support is now first class and they have added quite a few other new features that are really useful.
I think my only complaint now is that occasionally the interface can be a little clumsy - editing tables (both structure and data) is not always as easy as it should be.
But I would be surprised if these things weren't polished up more as time goes on as the developers are very quick to respond and keen to deliver a quality product. (Which they have..)
mrgrieves reviewed v1.2.7 on Sep 9, 2003
Absolutely brilliant. Replaces both Microsoft SQL Enterprise Manager and Query Analyzer and adds some hugely useful features of its own - autocomplete, version history, sourcesafe integration etc.
My only complain is that FOR XML AUTO doesn't work properly (although the app can generate its own XML).
But the developers are extremely friendly and response quickly to bugs and are very open to feature requests so I'm sure they will fix this one.
I'm looking forward to seeing what they come up with next.
mbgrove reviewed v1.05 on Apr 30, 2003
Since Kortirion appears to have covered the program itself rather well, I'll branch out. :-)
Like Kortirion, I have been using mssqlXpress since it first came out in beta. Like all programs in beta, it had some problems, but it definitely had potential. And the team at SpecApps have done an /awesome/ job of attaining that potential. You won't meet a more responsive development company. In looking back at how mssqlXpress has evolved, it is easy to see how much they listen to their customers. With SpecApps, you won't look back.
kortirion reviewed v1.05 on Apr 29, 2003
I wrote the first nasty review of this program (see bottom) and my, how things have changed. I have no idea why I was so pissed, but I actually have ended up using it daily ever since the release following that review. Great program, has removed almost all need for both QA and EM in our shop and everyone is required to use it. Updates are regular and actually add quite a few new features. It is still in active development, one of the newest features being an execution plan simliar to QA's.
It's got table structure editing, a data editor, query builder, code complete (visual studio style), reports, templates, an awesome 'verify' feature which is better than syntax check, and tons of other stuff I can't even remember right now. Just keeps getting better.
Keep QA around in case you need to run the indexing wizard or use a few of it's other features that haven't made it over yet.
It does require that you run the 'server' install to create a database, so you do need to have a sql server you can add it's database too. Keeps trak of the servers you connect to, vss settings, etc. there.
Andrei Rantsevich reviewed v0.996a on Feb 17, 2003
Could be a good substitute for Query Analyzer. It has a lot of extra features, like Source Code sontrol through VSS and code complete assistant, and what is also important - it is constantly developed and improved - even upon individual wish (if your request is really reasonable). We currently have switched to this product and currently Query Analyzer is needed only for Debug and Execution Plan.
DelphiRacer reviewed v0.996a on Feb 17, 2003
I have nothing but good news to report about this program, they have an A class web site with a user forum, only ever had one or two problems accessing there site. The guys have always replied promptly to my request and there listen to your suggestions when it comes to new features or bugs you've found.
InJustice reviewed v0.996a on Feb 17, 2003
downloaded fine for me. I got my demo code through the program..and their website loads with no problems. no 404 here.
have you emailed them asking what the deal is? i've emailed them a few times, they usually reply pretty promptly.
Elfric reviewed v0.996a on Feb 17, 2003
There's already an excellent program called iPhoto. If you want the real thing, and not a half-baked rip-off, try visiting http://www.apple.com/iphoto/ -- of course, if you're running Windows, you'll need to upgrade your computer in order to run it :-?
SpecApps reviewed v0.996 on Feb 5, 2003
Due to problems with our ISP We have moved to a different service and a proper point to point connection and a static IP address. This will make our website more reliable.
Our files are now hosted in the USA on a T1 and T3 connection. This takes pressure off our site and improves download speed for all users.
Thank you VERY much for your patience! —The XpressApps Team
DelphiRacer reviewed v0.96 Beta on Nov 14, 2002
The program continues to improve. The interface is now far superior to QA although still a few issues with error messages. I would recommend this product to any serious SQL Developer out there.
mrgrieves reviewed v1.2.9.5 on Mar 17, 2004
(For 1.3.0.6) - this application just keeps improving. The XML support is now first class and they have added quite a few other new features that are really useful.
I think my only complaint now is that occasionally the interface can be a little clumsy - editing tables (both structure and data) is not always as easy as it should be.
But I would be surprised if these things weren't polished up more as time goes on as the developers are very quick to respond and keen to deliver a quality product. (Which they have..)
mrgrieves reviewed v1.2.7 on Sep 9, 2003
Absolutely brilliant. Replaces both Microsoft SQL Enterprise Manager and Query Analyzer and adds some hugely useful features of its own - autocomplete, version history, sourcesafe integration etc.
My only complain is that FOR XML AUTO doesn't work properly (although the app can generate its own XML).
But the developers are extremely friendly and response quickly to bugs and are very open to feature requests so I'm sure they will fix this one.
I'm looking forward to seeing what they come up with next.
mbgrove reviewed v1.05 on Apr 30, 2003
Since Kortirion appears to have covered the program itself rather well, I'll branch out. :-)
Like Kortirion, I have been using mssqlXpress since it first came out in beta. Like all programs in beta, it had some problems, but it definitely had potential. And the team at SpecApps have done an /awesome/ job of attaining that potential. You won't meet a more responsive development company. In looking back at how mssqlXpress has evolved, it is easy to see how much they listen to their customers. With SpecApps, you won't look back.
kortirion reviewed v1.05 on Apr 29, 2003
I wrote the first nasty review of this program (see bottom) and my, how things have changed. I have no idea why I was so pissed, but I actually have ended up using it daily ever since the release following that review. Great program, has removed almost all need for both QA and EM in our shop and everyone is required to use it. Updates are regular and actually add quite a few new features. It is still in active development, one of the newest features being an execution plan simliar to QA's.
It's got table structure editing, a data editor, query builder, code complete (visual studio style), reports, templates, an awesome 'verify' feature which is better than syntax check, and tons of other stuff I can't even remember right now. Just keeps getting better.
Keep QA around in case you need to run the indexing wizard or use a few of it's other features that haven't made it over yet.
It does require that you run the 'server' install to create a database, so you do need to have a sql server you can add it's database too. Keeps trak of the servers you connect to, vss settings, etc. there.
Andrei Rantsevich reviewed v0.996a on Feb 17, 2003
Could be a good substitute for Query Analyzer. It has a lot of extra features, like Source Code sontrol through VSS and code complete assistant, and what is also important - it is constantly developed and improved - even upon individual wish (if your request is really reasonable). We currently have switched to this product and currently Query Analyzer is needed only for Debug and Execution Plan.
DelphiRacer reviewed v0.996a on Feb 17, 2003
I have nothing but good news to report about this program, they have an A class web site with a user forum, only ever had one or two problems accessing there site. The guys have always replied promptly to my request and there listen to your suggestions when it comes to new features or bugs you've found.
InJustice reviewed v0.996a on Feb 17, 2003
downloaded fine for me. I got my demo code through the program..and their website loads with no problems. no 404 here.
have you emailed them asking what the deal is? i've emailed them a few times, they usually reply pretty promptly.
Elfric reviewed v0.996a on Feb 17, 2003
There's already an excellent program called iPhoto. If you want the real thing, and not a half-baked rip-off, try visiting http://www.apple.com/iphoto/ -- of course, if you're running Windows, you'll need to upgrade your computer in order to run it :-?
SpecApps reviewed v0.996 on Feb 5, 2003
Due to problems with our ISP We have moved to a different service and a proper point to point connection and a static IP address. This will make our website more reliable.
Our files are now hosted in the USA on a T1 and T3 connection. This takes pressure off our site and improves download speed for all users.
Thank you VERY much for your patience! —The XpressApps Team
DelphiRacer reviewed v0.96 Beta on Nov 14, 2002
The program continues to improve. The interface is now far superior to QA although still a few issues with error messages. I would recommend this product to any serious SQL Developer out there.
SpecApps reviewed v0.94 Beta on Oct 18, 2002
Hi to all the feedback and comments thankyou, we are constantly developing and improving this application so that as a developer/administrator it provides a tool that makes it a joy to work with SQL Server. We are currently working on VSS but not sure when it will be included we have 8 staff working on this project at current at resources can get stretched so please be patient.
KairyLee reviewed v0.93 Beta on Oct 15, 2002
This is a very handy tool for any database developer. The code complete feature is really nice, just a bit slow. I don't have to open Enterprise Manager anymore to find out what tables and columns I have created, the code complete list all the tabels, views, procs and columns as you type. Being able to edit multiple proc is fantastic, when you have to refer to other procs all the time. The idea of the change history works really well.
DelphiRacer reviewed v0.93 Beta on Oct 14, 2002
The code templates in the editor windows are fantastic. The code complete feature when editing a stored procedure, trigger, view or sql script is a great feature but a very slow.
NathanBourke reviewed v0.91 Beta on Oct 10, 2002
Great litle program for editing and creating all of my Stored Procedures. Love the ability to be editing more than one SP at the same time, been looking for just that for ages. Version History is a good idea for when I stuff up and need to go back to what I had half an hour ago. Scripting is good for most things, SP's, Views, Triggers, Functions but is lacking in the table area. I've been using it for a couple of days now and will definitley be forking out the dollars for it.
Lord_Tool reviewed v0.91 Beta on Oct 10, 2002
Interesting concept. Code history is nice, good nuffie protection, doesnt hurt to have old versions lying just in case.
I like the search on the object windows, found that by accident, theres probably a bunch of stuff like that in it, needs documentation, but i assume thats on its way.
Polish it off and itll be a product worth looking into.
automatrix reviewed v0.91 Beta on Oct 8, 2002
Not sure what all this fuss is about - all betas needs polishing. This tool has great potential, and i am already becoming reliant on it - especially the version history feature.
I also adore the simple feature of being able to view/edit more than 1 stored proc at a time (unlike Enterprise Managers modal window). Doesn't really attempt to replace EM or QA entirely but i found it to became my tool of choice very quickly ( 2 days ) for most DB tasks i perform as a developer.
Seems to be dying for table editting, but i am assured this will be included shortly - I also forwarded a few suggestions for additional features - they were very pleased to receieve feedback.
I did not encounter the problems listed in other reviews.
NOTE.. I am dismayed to see such destructive criticism from just one reviewer. Is he a competor, or just the resident grump? This is the first beta i have reviewed here, and i only commented coz i LIKE it, and would like to see it even better.
MKaine reviewed v0.91 Beta on Oct 8, 2002
Install is very good in this version. Having a udl come up so I can select which SQL server to work with is great I created two udl's one for home and one for work and I get to select between both. Beats QA in multiple server support, and the verify button is actual seeing if the query will excute not just with it is syntax correct. Having all my code saved in a sigle database means I can back this up and take it home. I know can have all my Stored Procs and Triggers encrypted from the day they were created. The abiltiy to script any or all of the options makes this a great tool compared to other QA replacements out there on the market. Value for money at close to $60 I reckon its great and it seems to be getting better all the time. I'm in and I have found all the information by clicking on there mssqlXpress Homepage link seems these guys at www.xpressapps.com are doing a great job.
420sg reviewed v0.91 Beta on Oct 8, 2002
Installed it on XP Pro. The shortcuts didn't work. It would work from the program menu. Finally got it to open with the "open with" function. Could get it to full screen. Tried to uninstall it and wouldn't uninstall, either from the menu or from the control panel. Had to manually delete all the files and take out the registry keys. Needs some serious work.
DelphiRacer reviewed v0.91 Beta on Oct 8, 2002
Wow what a change a few days makes, much improved installation and a the bugs I had found have gone keep up the great work.
DelphiRacer reviewed v0.9 Beta on Oct 7, 2002
As a beta it was a bit difficult to setup but once I read the readme file I worked out it wanted to be installed on the server so it could install it own database which appear to keep all of the information. I was than able to copy the client files to my computer and use the application. Very good cocept well thought out I'll be interested to see if they listen to my feedback. Overall once its setup and running its a damm side easier than having Query Analyzer and Enterprise Manager both open and it has the potential to be a real winner. I'm going to keep using this and see where they go.