Enhance your database skills - Jump start on EnterpriseDB

Installation and basic features of EnterpriseDB

Postgres is the well known and most used Open Source OLTP database available today. EnterpriseDB sits atop Postgres and leverages it to provide enterprise capabilities to Postgres users. EnterpriseDB is available for Windows platform as well. It has most of the necessary features of an enterprise class such as advanced development, monitoring, migration and administrative tools with a stable environment. It also has plug-in capabilities for Oracle. In the present form EnterpriseDB claims cost effectiveness versus Oracle and better scalability than MySQL. It can easily integrate with most applications such as Java, Ajax, Ruby, Drupal etc.

Read on...
http://www.packtpub.com/article/installation-and-basic-features-of-enterprisedb

Visual Studio 2008 and SQL Anywhere 11 Integration

On Installing the SQL Anywhere 11

Visual Studio 2008 Integration

Breaking news!!

On Installing the SQL Anywhere 11

Register as a developer and get Panorama_windows_Beta (263 MB) from Sybase web site.

This one is pretty easy to install. I am sure the release edition will be as easy. Double click the downloaded file to kick off the installer. You see the Welcome Screen.

Click Next and get to see the License (Better read it). It looks like this is software has international exposure and widely used.

Accept the license and click Next. Verify Server licensing information and click Next.

Check out how much resource you have and accept the complete. Click Next.

Click on Install on Ready to Install Screen.

Installing SQL Anywhere 11 Progress screen shows up.

Hang around for a while till the process gets completed.

You are done!!







Nothing can be easier than this.

Now the fun begins. Go to Start |All Programs |SQL Anywhere 11 and you can see all the goodies you got.

Visual Studio 2008 Integration Features

If you have Microsoft Visual Studio Installed you can open and verify that hooks to integrate VS with SQL Anywhere is ready to go. You can get to Sybase Central (Management interface for the SQL Anywhere products you downloaded) as well as Interactive SQL where you can test your SQL skills. You need authentication which is Username: dba and Password: sql

You can also Browse using the SQL Anywhere Explorer from within VS 2005 (also VS2008).

If you are used to ODBC and adept at it go ahead and open the ODBC Manager and verify you have the correct driver.

You can learn a number of things about this database products following articles at this link:

http://hodentek.blogspot.com/2007/06/sql-anywhere-10-related-articles.html

Happy learning!

Breaking news!!

PS: As of this writing you can download a Developer's edition by registering at the Sybase site.

Panorama: SQL Anywhere 11's BETA is out

I down loaded 'Panorama' and installed it on the same machine side by side with others SQL Server 2005, Oracle 10G Xe, IBM DB2 and also SQL Anywhere 10.

Initial findings extremely encouraging...

* The installation was uneventful, easy and smooth. A very positive feature

* The document installation was easy

* Visual improvements many, especially the dialogue boxes for connections [ the only one I evaluated in detail]

* The installation updated the .NET related items that you would see on VS 2005, namely, the Sybase Central and ISQLAnywhere.

* Ás per my original wishes, SQL Anywhere queries can now return data in 'JSON'

* Here is a quick view of the 'Demo' database's overview in Sybase Central 11.