.NET news » Database

Many times you need to import data from different databases into your SQL Server database. If you do not have SQL Server Enterprise manager or similar tools then it becomes very tedious to import such data. This is especially true when you are working with SQL Server Express Edition or MSDE. BinaryIntellect Bulk Copy Tool allows you to import data from SQL Server, Access, Oracle and ODBC databases into your SQL Server database. Developed using new ADO.NET 2.0 features the tool is very easy to use and FREE.

Lattice.DataMapper is a tool that maps .NET objects to and from an underlying relational database using external XML configuration and mapping files. Features included object pre-fetch (one-to-one, one-to-many, and many-to-many), objects cache, batch job, distributed transaction.

If you develop an application using SQL Server data provider and later on decide to use Oracle you must change your code. At first thought using OLEDB data provider or ODBC data provider might come into your mind. However, considering the performance penalty that is not always a good idea. Won't it be nice to have a generic data access layer which will allow you to write provider independent code? That's exactly what this article will talk about.

Access-to-MySQL, one of the oldest tools to migrate Microsoft Access databases to MySQL server, has been updated. New version of the software converts relationships between tables.

Persistent Datasets is a Persistence Layer for .NET 2.0 that allows using Native C# Queries for querying database. The latest release includes SQL Server 2005 support and improved Native Queries syntax.

Learn about the new features in the typed DataSet class and the new TableAdapter class that are generated by Visual Studio 2005, as well as the tools for designing these classes.

SQL Server 2005 offers a completely redesigned SQL Server Integration Services engine, formerly known as Data Transformation Services. It includes many new features such as built-in support for Fuzzy Lookups and Fuzzy Groupings, which help you build powerful data-cleansing solutions. This article provides an overview of fuzzy searching techniques and a dissection of the underlying fuzzy search technology implemented in SQL Server 2005.

The topic of using or not using stored procedures reaches the level of religious fervor in many quarters. Douglas Reilly, a Microsoft MVP, weighs in on the topic with an in-depth analysis.

ADO.NET supports many ways to manage memory-resident data returned in a DataSet. This example demonstrates how to use the additional functionality exposed by ADO.NET to sort and filter data.

Data Points: XML Features in SQL Server 2000