How can we help you today? How can we help you today?
andersom
Activity overview Badges (0) Posts (5) Comments (19)

Comments

Sort by recent activity
Ah, that works much better. So, to clarify, in SDC 7 the command line syntax for selecting specific tables was: /include:table:\[table1\]^|\[table2\]^|\[table3\] Whereas in SDC8, the following syntax is correct? /include:table:^table1$^|^table2$^|^table3$ That seems confusing to me... Also, your online documentation seems to indicate that the square bracket syntax is correct, not the $ syntax you posted, and probably needs to be updated. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. SDC 8 shows DBs as identical, SDC 7 finds differences?
Ah, that works much better. So, to clarify, in SDC 7 the command line syntax for selecting specific tables was:/include:table:\[table1\]^|\[table2\]^|\[table3\] Whereas in...
0 votes
If I quote the table name, then it does sort-of work, however it treats the table name as a wildcard, and I need to match only the exact table name. See the following: E:\>"E:\Red Gate\SQL Data Compare 8\SQLDataCompare.exe" /verbose /server1:the_real_ prodc /server2:ladbmo01\lamom /database1:pricing /database2:pricing /include:table:"tbl_ppws_run_results" Red Gate SQL Data Compare Command Line Utility V8.0.5.48 ============================================================================== Copyright c Red Gate Software Ltd 1999-2009 Serial Number: Comparing database the_real_prodc.pricing with database ladbmo01\lamom.pricing... Registering databases Mapping Comparing databases Finished Summary Information =============================================================================== DB1 = the_real_prodc.pricing DB2 = ladbmo01\lamom.pricing Object type Name Records DB1 DB2 ------------------------------------------------------------------------------- Table [dbo].[tbl_ppws_run_results] 44597 >> Table [dbo].[tbl_ppws_run_results] 6167 << Table [dbo].[tbl_ppws_run_results_cac] 77 <> <> Table [dbo].[tbl_ppws_run_results_cac] 757138 >> Table [dbo].[tbl_ppws_run_results_cac] 117318 << Table [dbo].[tbl_ppws_run_results_comp_scale] 867 >> Table [dbo].[tbl_p...un_results_comp_scale_dtl] 867 >> Table [dbo].[tbl_ppws_run_results_sfee_fee] 2206 >> Table [dbo].[tbl_ppws_run_results_sfee_fee_dtl] 2206 >> ------------------------------------------------------------------------------- OK In order to just compare the single table named tbl_ppws_run_results, I'm putting square brackets around the table name, which was the correct way to do it in version 7, however doing it that way now gives me the following results: E:\>"E:\Red Gate\SQL Data Compare 8\SQLDataCompare.exe" /verbose /server1:the_real_ prodc /server2:ladbmo01\lamom /database1:pricing /database2:pricing /include:table:\[tbl_ppws_run_results\] Red Gate SQL Data Compare Command Line Utility V8.0.5.48 ============================================================================== Copyright c Red Gate Software Ltd 1999-2009 Serial Number: Comparing database the_real_prodc.pricing with database ladbmo01\lamom.pricing... Registering databases Mapping Comparing databases Error: The selected objects are identical or no objects have been selected in the comparison. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. SDC 8 shows DBs as identical, SDC 7 finds differences?
If I quote the table name, then it does sort-of work, however it treats the table name as a wildcard, and I need to match only the exact table name. See the following:E:\>"E:\Red Gate\SQL Data C...
0 votes
The latest update that you posted does not solve the original problem. It does fix the "Object reference not set to an instance of an object." error, but the "The selected objects are identical or no objects have been selected in the comparison." error remains. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. SDC 8 shows DBs as identical, SDC 7 finds differences?
The latest update that you posted does not solve the original problem. It does fix the "Object reference not set to an instance of an object." error, but the "The selected objects are identical or ...
0 votes
Quick update: I installed the latest cumulative patch for SDC 8 to see if it would help, now I'm getting a different error: E:\>"E:\Red Gate\SQL Data Compare 8\SQLDataCompare.exe" /verbose /server1:the_real_prodc /server2:ladbmo01\lamo m /database1:pricing /database2:pricing /include:table:\[tbl_ppws_cfg_maint_expense\] Red Gate SQL Data Compare Command Line Utility V8.0.5.42 ============================================================================== Copyright c Red Gate Software Ltd 1999-2009 Serial Number: Comparing database the_real_prodc.pricing with database ladbmo01\lamom.pricing... Registering databases Mapping Error: Object reference not set to an instance of an object. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. SDC 8 shows DBs as identical, SDC 7 finds differences?
Quick update: I installed the latest cumulative patch for SDC 8 to see if it would help, now I'm getting a different error:E:\>"E:\Red Gate\SQL Data Compare 8\SQLDataCompare.exe" /verbose /serve...
0 votes
Looks like that fixed the problem. Thanks! / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. SDC selecting from every table in DB. Bug?
Looks like that fixed the problem. Thanks!
0 votes
Excellent, thanks for the reply! / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. SDC selecting from every table in DB. Bug?
Excellent, thanks for the reply!
0 votes
Ah, I believe I've solved my problem. The issue was that I did not want users or logins synced to the destination DB, but do want roles and role permissions synced. When I executed the sync command using /options:d,iu, the "include dependancies" inherent in the "d" option was what was messing things up. I changed my options to if,iw,ifg,iup,iweo,iu,irpt and everything seems to be working properly now. For reference, my full command-line is thus: "E:\Red Gate\SQL Compare 6\SQLCompare.exe" /verbose /exclude:user /exclude:schema /exclude:StoredProcedure:sp_MS* /options:if,iw,ifg,iup,iweo,iu,irpt /server1:x /server2:y /database1:z /database2:z /sync This results in syncing tables and roles, and granting permissions to the roles, but excludes users and logins as desired. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Enhancement request - Syncing permissions
Ah, I believe I've solved my problem. The issue was that I did not want users or logins synced to the destination DB, but do want roles and role permissions synced. When I executed the sync command...
0 votes
Nope, excluding the ip doesn't work. See the following excerpt from the log: Altering permissions on [dbo].[SomeTable] Msg 15151, Level 16, State 1, Server XXXXX, Line 1 Cannot find the user 'SomeUser', because it does not exist or you do not have permission. See, because the users don't exist on the destination, omitting ip results in permission setting failing, causing the entire process to fail. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Enhancement request - Syncing permissions
Nope, excluding the ip doesn't work. See the following excerpt from the log:Altering permissions on [dbo].[SomeTable] Msg 15151, Level 16, State 1, Server XXXXX, Line 1 Cannot find ...
0 votes
I'm going to feel rather foolish if the solution to my issue is already in place and that simple. Let me give it a try and get back to you ;-) / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Enhancement request - Syncing permissions
I'm going to feel rather foolish if the solution to my issue is already in place and that simple. Let me give it a try and get back to you ;-)
0 votes
No, I'm finding that ip is ignoring permissions granted to roles. iu is working just fine. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Enhancement request - Syncing permissions
No, I'm finding that ip is ignoring permissions granted to roles. iu is working just fine.
0 votes
Total activity
30
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
6