Ars Technica

SQL Server - Copy Table in Same Database

I need to copy a mass amount of tables in SQL Server to the same database (obviously renaming the tables). I need to include constraints, keys, indexes, etc, as well as data. (we need to copy an old ...
Redmond Magazine

Restoring a Database to an Older Version of SQL Server

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...
TechRepublic

Step-By-Step: Learn the basics of using DTS in Microsoft SQL Server

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000. We may earn from ...
Ars Technica

SQL server bulk copy - can you make it ignore duplicates copying into table?

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So as ...
dbta

Catalogic Copy Data Management Adds Support for Oracle, SQL Server, EMC Unity

Catalogic Software, a provider of software-defined copy data management (CDM), has released ECX 2.4, the newest version of its software platform that adds Oracle and Microsoft SQL Server ...