Transferring a Database Using the SSIS Designer - The Source and Destination Servers and Databases

(Page 2 of 7 )

The next picture shows the source and destination servers used in this tutorial. The source server is the SQL 2005 Enterprise Server Hodentek/MYSORIAN. The destination server is the HodentekSQL Express Server. The database, named TestBase on the SQL 2005 Server, will be transferred to the SQL Express Server using the Transfer Database Task in Visual Studio 2000. The TestBase database does not exist at this point in the SQL Express Server. The TestBase database in SQL 2005 Server has system tables as well as two user tables, Argentina and TestValid, as shown.

The next picture shows some of the general details of this database.

The SQL 2005 Server folders on this computer are arranged as shown in the next picture. The MSSQL.1 and MSSQL.4 folders refer to the SQL 2005 Server and the SQL Express Server respectively. The MSSQL.2 and MSSQL.3 folders belong to the OLAP and Reporting Services. The folder location for all these is: C:Program Files Microsoft SQL Server. We may have to use this information in this tutorial.

.  

Next: Creating a Business Intelligence Project >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Transferring a Database Using the SSIS Designer

· SSIS is well integrated with the Visual Studio 2005. In SQL 2000 server it was a...    · Good tutorial. However, what do you do when you get the error below because one or...   >>> Post your comment now!