Hi All,
I have business requirement that would require few tables from DATABASE1 on SERVER1 to be copied to DATABASE2 (new database) on SERVER2. The Size of these 3 tables coming to 7GB.
The problem now is 2 of the fields in DATABASE1 are text fields. these 2 fields need to be made as date fields in the new database (DATABASE2). I am wantedted to use DTS package to copy these 3 tables across the server.
Do I need to take any precausions?! Because I wanted to be careful, since I am copying to the Production Server.
Please let me know if there any issues with this approach.