Here are my recent articles on EnterpriseDB

I find it interesting to write articles on EnterpriseDB. Here are a couple of the recent ones.


Transferring a table in a MS Access 2003 database to PostGres using SQL Server Integration Services
This is on a site to which you should subscribe. But you can sign up as a guest to read this article. SSIS 2008 is used to make the transfer

Creating a linked Postgres Server on SQL Server 2008
SQL Server 2008 provides a convenient GUI to make this possible. You will be using the ODBC provider from EnterpriseDB

Creating a VB.NET application with EnterpriseDB
Visual Studio 2008 is a great IDE for developing a desktop application such as this one.


Migrating from MS SQL Server 2008 to EnterpriseDB
Migration Studio from EnterpriseDB makes this a piece of cake.

Installation and basic features of EnterpriseDB
Install this product and take it to a test drive. You will like it

More to come in the coming months.

Exporting data from MS Access to EnterpriseDB

These days no software has monopoly and businesses use a software mix that makes
business sense to them. Because of this businesses sometimes need to migrate, only
a part or all of their data to another kind of software.

This article discusses how to move data from MS Access to EnterpriseDB. Although EnterpriseDB
has a custom Migration tool, it does not provide out of the box support for MS ACCESS. However
MS ACCESS can export a table to EnterpriseDB using an ODBC Data connection.

This article appeared on the Databasedev.co.uk site recently,

 Exporting a table from Microsoft Access to EnterpriseDB




For a number of other EnterpriseDB related articles search my blog.

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

EnterpriseDB application with Visual Studio 2008

Visual Studio 2008 is a powerful IDE that can access many different data sources. Combined with SQL Server 2008 it can deliver end-to-end support for many kinds of applications. Add a little bit Silverlight and a dash of jQuery, the clients will be experiencing unheard of delights.

This article shows how you may leverage VS2008 to access data on the EnterpriseDB.

Creating a VB.NET application with EnterpriseDB

The following two articles are recommended before you read the above if you are new to EnterpriseDB.
installation and some basic features of EnterpriseDB 
Migrating from MS SQL Server 2008 to EnterpriseDB

Data Transfer from MS Access to EnterpriseDB's PostGres

EnterpriseDB sits atop Postgres, the well known open source database server and leverages it to provide enterprise capabilities to Postgres users.

Out of the box EnterpriseDB's Migration Studio supports migration from SQL Server, Postgres and Sybase only. In this article, the Microsoft Integration Services is used to transfer a table form Microsoft Access 2003 to a database  on the EnterpriseDB Postgres server.

MS SQL Server Integration Services 2008 is a great product that handles various ETL Processes very effectively. However, sometimes its error messages can be confusing as you will see in this article. For example, where as the task execution has failed in this example, the data transfer has taken place.

Read on,

Transferring a table in a MS Access 2003 database to PostGres using SQL Server Integration Services 


This is a subscription site and you can login as guest and read free or join as a member using link for SSWUG.ORG on the main page.

If you are new to EnterpriseDB you may also want to read my other article first

Installation and basic features of EnterpriseDB

Generating a report using data on an EnterpriseDB Server

This article with the link shows step-by-step how you may retrieve data from a database on a Postgres Plus server and display the results in a report generated using Report Builder 2.0. Report Builder 2.0 is a report building and maintaining tool provided with SQL Server 2008. The evaluation version of SQL Server 2008 Enterprise edition was used in this tutorial. Report data is obtained via an ODBC DSN. The connection uses an EnterpriseDB ODBC driver that gets installed on the computer when EnterpriseDB is installed.


 Authoring an EnterpriseDB report with Report Builder 2.0


For 50 more articles of this nature read the book,
'Learn SQL Server Reporting Services 2008 ' by the author.

How to create a linked Postgres Server on SQL Server 2008?

This article published on the DotNETSlackers site describes in detail setting up a linked EnterpriseDB server on SQL Server 2008. Methods to query the linked server as well as executing statements remotely on the linked server are also described.

Creating a linked Postgres Server on SQL Server 2008

Other related articles:

http://hodentek.blogspot.com/2009/01/enhance-your-database-skills-jump-start.html

http://www.packtpub.com/article/migrating-from-ms-sql-server-2008-to-enterprisedb

http://www.packtpub.com/article/creating-vbnet-application-with-enterprisedb

http://www.sswug.org/articles/guestarticle.aspx?id=43535

EnterpriseDB ratchet up its Postgres Plus Standard Server one more rung

With the release of v8.4 today this open source database is moving ahead full steam. The new release is reported to include many new features such as,

Parallel Database Restore
Per-column permissions
Per-database collation
ANSI SQL 2003 windowing functions
Provide pre-integrated and pre-installed enterprise add-on modules
Value integrated testing of add ons
and many, many more...

Download page for Postgres Plus Standard Server 8.x is
here.

For getting one-up on working with EnterpriseDB read my comprehensive earlier articles on this product at:
http://hodentek.blogspot.com/2009/05/here-are-my-recent-articles-on.html

Try out EnterpriseDB and get a taste of Open Source DB

You want to experience the use of an enterprise class of a relational database, try out EnterpriseDB which packages the latest version of PostgreSQL, a popular open source database which has been improved to address all deficiencies compared to the other popular database MySQL. Now what you have is a high reliability scalable database with superior performance that has encouraged many users to move out of Microsoft SQL Server according to some polls conducted. Download EnterpseDB and enjoy.

You have a user friendly management studio that you can use to get all that you need to work with Postgres.

Designing a data access page with EnterpriseDB Data

Microsoft Data Access Pages (DAP) was a great hit when suddenly data could be web enabled dynamically and user could say good bye to static HTML. There are still many DAPs fans who continue to use DAPs. With Office 2007 that ability was lost and Microsoft showed that ability was available in MS SharePoint Services. However, there are many who cannot move over to Office 2007 as they have their resources (programs) tied to older technologies.

The following article brought to you by EggHeadCafe.com is addressed to those folks and DAC aficionados and shows step by step how you may develop a DAP with data on a Postgres Database.

Please review the article at eggheadcafe.com

Web access to EnterpriseDB with Data Access Pages

Creating a database in EnterpriseDB

You want to learn working with Postgres and your computer is working off Windows OS like mine (Windows XP Pro). The first thing you my want to do is to download the Advanced Server from EnterpriseDB's web site as detailed in this article. Once you have the server you may want to create a database with which you can practice. This post shows you step by step how you may take this important step. Do not worry, this will not be a production server and this database is just for practice and give yourself maximum privileges. Do not worry about security even, that will have to be taken care of before you face the public.

Right click the Databases node to invoke a drop-down pick list

Click New Database... to open the new window as shown. You have to provide a name to the database. I have given MoveTable as the database name. When you installed you provided a owner name. You should be able to find this in this drop-down list. You may provide a comment to remind why you created this in the first place. For now you can accept other defaults in the Properties tab.

Also accept the defaults in the next tabbed page Variables.

In the Privileges page give Public (you will be the only 'Public') the maximum privilege as shown.

In the SQL tab you will see the script that will create the database.

When you click OK you will have created a database as you see in the databases node (Refresh if you have to)

Presently there is no table in this database as shown.

In the next step you will have to create a table, or import a table from another database, or even from another server.  That will be in a future post.

SQL Server Report based on an ad hoc query

In my previous article on DotNetSlackers site I described creating an EnterpriseDB Linked server on SQL Server 2008. In this article the idea is carried forward to create a SQL Server 2008 report based on a distributed Ad hoc query using data on the SQL Server 2008 and a linked MS Access 2003 database. The article describes step by step the procedure to create such a report using Report Builder 2.0. The idea is generic and can be adopted for other scenarios as well.

Review the following article for more details,
Authoring a SQL Server Report Using an Ad hoc query

Do more by learning to work efficiently with SQL Server Reporting services.

* Get two free chapters of my book 'Learn SQL Server Reporting Services 2008' from the pubisher's web site.

Migrating from SQL Server 2008 to Postgres on EnterpriseDB

With many database vendor products in the market and data intensive applications using them, it is often required to port the application to use the data or, migrate the data so that the application can use it. Migration of data is therefore one of the realities of the IT Industry. Some of the author's previous articles on migration can be found at this link.

Read the full story here .