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.

Using the interface, you can select a database source to sync, whether it be local or on another server PC, and connect it to your local database to synchronize data and settings.

I did not need actual data; an empty copy of the latest database would suffice. I could easily add a few test records for the demonstration after installing the database on my laptop. I created a copy ...

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 ...

Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.