Tag Archives: SQL Server 2008 DTS

Transferring Data – contd…

Previous Post The Database Copy Wizard The Copy Database Wizard lets you move or copy databases and their objects easily from one server to another, with no server downtime. Using this wizard, you can do the following: Pick a source and destination server. Select databases to move or copy. Specify the file location for the [...]

Transferring Data – Integration Services

Now will learn how to transfer large amounts of data to and from Microsoft® SQL Server® 2008 using a variety of import and export tools, including bcp, bulk insert, and SQL Server Integration Services.  The power of SQL Server can be magnified by connecting it to other data sources. What is Data Transfer? Copying Data [...]