I am transferring a database from SQL Server 2000 to SQL Server 2005. I am using 2005's Integration Services (SSIS) Transfer Database Task. In this task, I am using the "DatabaseOnline" method.
The database transfer seemed to work, except no Primary Keys, Identity settings, Foreign Keys or Default Values transferred over!
I have looked all over the property settings, and the internet, but I do not see any reference to including constraints. How do I include PK, FK, etc., constraints when I use the Transfer Database Task to bring over an old SQL Server 2000 database to 2005?