Activity overview
Latest activity by pmoore
Done. Ticket no: 81239 / comments
Done. Ticket no: 81239
I've just repeated the process using 2 tables from each db in 2 local databases on my PC. (much faster!!!!) and I still get the same problem.
The tables are empty. So the db's are only a few KB in size.
If it would be of use to you I could send you the db backups and the project file on Monday. (I'm about to leave for the weekend). / comments
I've just repeated the process using 2 tables from each db in 2 local databases on my PC. (much faster!!!!) and I still get the same problem.
The tables are empty. So the db's are only a few KB in ...
I just deleted my project and started again from the beginning, and got the same results.
Automap was showing as being turned back on. I had a look at the table field mappings were it displayed the automap feature and it has the mappings wrong.
I looked at the same table as earlier in this post (which does not display an automap icon) and it had the same incorrect field mapping as show in my screen shots.
So it seems to get it wrong whether automap is turned on or off, and whether it displays it has used automapping for a table or not.
This has taken me several hours.. / comments
I just deleted my project and started again from the beginning, and got the same results.
Automap was showing as being turned back on. I had a look at the table field mappings were it displayed th...
I have clicked restore defaults as suggested on the main table mapping screen.
I have also clicked the partial button and clicked restore defaults on that window.
If I select the same table as before and click partial and get a better looking view. as in fields with the same name line up, and fields with different names don't. [image]
However when I click compare, it still mismatches fields. [image]
I have also stopped and restarted SQL Compare, and also my PC. / comments
I have clicked restore defaults as suggested on the main table mapping screen.
I have also clicked the partial button and clicked restore defaults on that window.
If I select the same table as befo...
Hi. Sorry yes you are right it's SQL Compare.
Please move to appropriate forum. / comments
Hi. Sorry yes you are right it's SQL Compare.
Please move to appropriate forum.
SQL Compare field mapping incorrect
I have found that SQL compare is mismatching fields.
I've recreated tables with the same names and field names. The target (data warehouse has a few extra fields).
In the comparison window SQL comp...
SQL Compare field mapping incorrect
I have found that SQL compare is mismatching fields.
I've recreated tables with the same names and field names. The target (data warehouse has a few extra fields).
In the comparison window SQL comp...
>> if there is anything more we can do to improve this.
Not sure if this is the right place to make related suggestions.. But it would be great if we could limit the object types to be filtered and compared before opening a project.
I'm trying to compare a handful of tables which need to be mapped manually and my source db has 45,000 objects (7500 tables and 36,000+ CLR's). Each time the project refreshes it takes 10-15minutes.
This is frustrating because I only want to compare the table schema and datatypes for fields with matching names. / comments
>> if there is anything more we can do to improve this.
Not sure if this is the right place to make related suggestions.. But it would be great if we could limit the object types to be filtered an...
Thanks for adding this feature. I've just upgraded so I can take advantage of it. / comments
Thanks for adding this feature. I've just upgraded so I can take advantage of it.