The Export and Import Wizard is an extremely useful tool for transferring data. In fact it is the simplest tool to copy over data from one database to another and to create data transfer packages that can be persisted. Data can be transferred between SQL Servers (between versions of SQL Servers for example) as well as between even two non-Microsoft databases. Both Microsoft and proprietary data source providers are available to connect to many different database products.

In this article by Dr. Jayaram Krishnaswamy, we will be transferring data from an MS Access database to a database on SQLServer 2008. Both the source of data and the destination database are on the same machine, in this case a computer box running Windows XP Pro. There are two versions of the Import and Export Wizard and in this example the 32 bit version is used.

You may already be aware that Packt eBooks are an immediate and cost effective way of receiving one of our books and are a complete electronic version of the print edition. Therefore you're going to be pleased when you find out that, we're offering 70% discount off the eBook of Drupal Multimedia

Grab your copy NOW! This offer expires on July 5th, 2009!

In this two-part article by Jean Baptiste-Jung, we shall learn how to enhance user experience and make your blog a better place for the visitors. In the first part we saw how to use paginator, highlight searched text in search results, and use the CSS sliding doors technique within WordPress.

In this part, you will learn:

• Creating a drop-down menu for your categories
• Adding a breadcrumb to your theme
• Displaying related posts
• Displaying tabs on your sidebar

In this article by Jeff Cochran, we will be discussing about how to add security and membership to a Content Management system. we will divide this article in two parts. In this first part, we will cover configuring and using forms authentication, along with how to create the membership database and the login page.

In the previous part of the article by Hector R. Madrid, we learnt the basics of an External Table. It dealt with a brief description, procedure to create, and the compatibility of External Tables. In this part, we will discuss about the data transformation with External Tables. Finally, we will see the enhancements Oracle 11g has brought about in External Tables.