Default Value or Binding in "Transfer SQL Server Object Task"
- by Kronass
Hi,
I want to move 500 table from Database to other with their data and constraints all the tables have column who has default value, I used SSIS using "Transfer SQL Server Object Task" and I choose to copy all tables, copy data and primary keys, it copies the table except the default bindings
I tried in SQL Server 2008 CopyAllDRIObjects Property but still the same result.
How can I copy all tables from database to other with their data and maintaining their constraints.