• it will copy all objects (including constraints, PS, function etc, whatever valid for SQL server), at least its true for SQL server to SQL server. I dont know how it will behave with oracle.