CTP4 Multiple Issues/Observations
Hello guys,
After upgrading to CTP4 I have noticed a few issues resolved, but a couple new issues as well. For some database schema imports that worked on CTP4 only some tables, functions, etc are imported and when viewing the Schema Viewer table I see all of the objects that are missing denoted with yellow explanation points. I also get a collection of errors but the total number of errors does not match the total number of objects missing. An example of the errors we get: Error 1 Invalid column name 'N'. C:\<removed>\Database6\Database6\Schema Objects\Stored Procedures\rsp_RejectedPayments.proc.sql 182 1 Database6
Error 2 Invalid column name 'N'. C:\<removed>\Projects\Database6\Database6\Schema Objects\Stored Procedures\rsp_RejectedPayments.proc.sql 183 1 Database6
Error 3 Invalid column name 'Y'. C:\<removed>\Database6\Database6\Schema Objects\Stored Procedures\rsp_RejectedPayments.proc.sql 185 1 Database6
Error 4 Invalid column name ': '. C:\<removed>\Database6\Database6\Schema Objects\Stored Procedures\osp_GetAdvisorRoleAndStatus.proc.sql 26 1 Database6
Error 5 Invalid column name 'N'. C:\<removed>\Database6\Database6\Schema Objects\Stored Procedures\rsp_ReturnedPayments.proc.sql 144 1 Database6
Error 6 Invalid column name 'N'. C:\<removed>\Database6\Database6\Schema Objects\Stored Procedures\rsp_ReturnedPayments.proc.sql 145 1 Database6
Error 7 Invalid column name 'Y'. C:\<removed>\Database6\Database6\Schema Objects\Stored Procedures\rsp_ReturnedPayments.proc.sql 147 1 Database6
Also some of the other developers on my team have noticed the following:
Major issues I had seem to be resolved (from CTP3)
1. For DataCompare I couldn’t select a subset of the tables (ref tables). I had to do the whole database at once for it to work.
2. SchemaCompare would say that tables were the same that weren’t
New CTP4 issues we have noticed are:
1. Schema import does not generate files w/ permissions. This is a big problem. If this isn’t changed, we’ll need to maintain a separate script for 100’s of items manually.
2. Users and Roles are scripted, but users aren’t assigned to roles.
3. The preview for data generation plan shows invalid characters in the column data.
