I believe you can generate the primary keys after that if DTS don't preserve them. And I don't believe that views must be rewritten. I don't see any reason for that. The problem is with triggers because in PostGreSQL you use rules. And in SQL Server you don't have triggers before.