topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday March 29, 2024, 5:53 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: SQL Everywhere by Atlantis Interactive - a supercharged IDE for SQL Server!  (Read 10286 times)

arthurz

  • Participant
  • Joined in 2007
  • *
  • Posts: 5
    • View Profile
    • Donate to Member
Free SQL Server Integrated Development Environment is in town!

SQL EverywhereAtlantis Interactive's SQL Everywhere is a free and paid IDE for database developers and administrators
App URLhttp://www.atlantis-...featureshowcase.aspx
App Version Reviewed1.6.165
Test System SpecsWindows XP SP2 to Windows 7 with SQL Server 2005 and 2008R2
Supported OSesAny Windows OS newer than Windows 2000
Support MethodsContact info: http://www.atlantis-...aboutus/default.aspx
Upgrade PolicyBase price entitles for email support, bug fixes and minor upgrades, license discounts, upgrade cover
Trial Version Available?Trial is available in form of a freeware edition: http://www.atlantis-...compareeditions.aspx
Pricing SchemeFor pricing please see: http://www.atlantis-...urchase/default.aspx
Relationship btwn. Reviewer and Product REVIEWER: There is none.

Intro:

Atlantis SQL Everywhere is a SQL Server IDE (Integrated Development Environment) which supports all versions of Microsoft SQL Server from 2000 to 2008 (update: as of ver. 2.0.97 from Dec. 4, 2010 it also supports SQL Server code-named "Denali") and comes with the most fully-featured and accurate SQL Intellisense® engine available – use it to turbocharge your productivity.

If you use Management Studio or Enterprise Manager as your SQL editor, then you’re going to be amazed at what our SQL Server IDE SQL Everywhere can offer you over and above what you’re used to. The highly optimized Intellisense® engine provides you with in-place suggestions wherever you place your caret. Inside a stored procedure? No problem! Nested 10 levels down in an iterative cursor algorithm? No problem! Joining multiple SQL tables each with their own aliases? No problem! SQL Everywhere knows exactly what can be typed at any point and will let fill you in on this information unobtrusively, just when you need it most.

Please see the features:
http://www.atlantis-...featureshowcase.aspx

Who is this app designed for:

Anyone proficient in SQL (e.g. a database developer) or an administrator will benefit fro the application features.

The Good

Auto completion shortcuts work to let you type more by typing less: common statements are abbreviated to a few key strokes. Pressing tab after importing an identifier such as a table name intelligently creates a unique, short alias for you. Code snippets easily import common boiler-plate code fragments and highlight the areas to be edited.

Extensive syntax highlighting neatly colors what you type by class and function. Unique “Declaration Tracing” will identify the declaration position of identifiers and symbols that you’re referencing by hovering your mouse cursor over them.

But it’s not just about the ground-breaking code editor, SQL Everywhere is a SQL Server IDE that offers so much more...

The built-in data SQL export feature is an extremely handy way to automatically script SQL statements which can be kept for backup purposes or run against other databases to import data. The SQL Export is intelligent enough to manage the order of the exported statements so that upon import, referential integrity constraints do not produce errors.

“Auditing” stores the results, messages, errors & SQL from every execution. A powerful search feature lets you make sense of all this historic data, and allows you to find executions against a specific server, database or date range. Choose whether to search SQL, results and/or messages.

Execute a SQL statement on many databases at once using our SQL multiple server technology - “Multiple Execution” - a unique feature among SQL Server IDE products. Run on entire groups / servers, or select which databases to execute against. View results, messages and errors from each individual database, or view them all at once. These enterprise-level features have been thoroughly validated in the field against production-scale databases running under live environments and have proved time and time again to be invaluable.

The needs improvement section

Other the comment/uncomment buttons look completely the same and thus may be mixed up, nothing is wrong with this utility.

Why I think you should use this product

Have a problem finding where a column is referenced or used in a database? Want to write SQL code at a speed of light and without errors? Need to compare results? Format SQL to be neat? Need a test mode for your database manipulations? If the answer is yes to even one of the above - the tool is a must have for you!

How does it compare to similar apps

Dare to compare? See this blog post: http://geekswithblog...re-vs.-toad-for.aspx

Conclusions

SQL Everywhere massively speeds up database development and administration. The savings in development time make a significant contribution to ensuring that your project will deliver on time solutions and that they’ll be spot on, first time.


« Last Edit: January 03, 2011, 02:54 PM by arthurz »

KynloStephen66515

  • Animated Giffer in Chief
  • Honorary Member
  • Joined in 2010
  • **
  • Posts: 3,741
    • View Profile
    • Donate to Member
Thanks for the review  :Thmbsup:

Ill certainly be mentioning this to a few people who deal with SQL on a daily basis, and might give it a thought next time I need an IDE to deal with an SQL database  8)

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,288
  • Tell me something you don't know...
    • View Profile
    • Renegade Minds
    • Donate to Member
Nice. Thanks for the info there!

http://www.atlantis-...compareeditions.aspx

And a community edition~! Yay~! :D

I use DeZign for Databases for, well, database design, but this would be a perfect companion for it. It's like Query Analyzer on steroids. :D

Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Thanks for sharing the review -- your blog looks good too!

Quick note: arthurz, please edit your first post to specify your relationship with the product/company, if any, or specify that there is none.

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,288
  • Tell me something you don't know...
    • View Profile
    • Renegade Minds
    • Donate to Member
Downloading is a bit on the bizarre side. There's no "download" for it at all. You need to "purchase" the free version and go through the checkout process and then you get the download link. There might be somewhere else to download it, but it's not obvious and I didn't want to fart around scouring the site for it.
Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker