• To transfer data you can use BCP or SSIS (create from scratch or use import/export wizard from SSMS). These perform real good. Keep in mind the key-relations between the tables or remove them temporarily.

    You could also use scripts (search SSC scripts or internet) to generate INSERT commands of your data, but that will perform much slower.

    Post error messages if transferring data fails to work...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **