Activity overview
Latest activity by laurieb
Simon
Thanks for that. I've managed to do it where the two tables are in the same database. A suggestion that the user interface could be a bit more explicit in future versions. / comments
Simon
Thanks for that. I've managed to do it where the two tables are in the same database. A suggestion that the user interface could be a bit more explicit in future versions.
Thanks for the link. In your example, when you remap a table both source and destination tables have the same name "WidgetPrices". I would like to copy data from "WidgetPrices" into say "WidgetPricesNew" and I can't see how the "Map" diakog allows me to to do that / comments
Thanks for the link. In your example, when you remap a table both source and destination tables have the same name "WidgetPrices". I would like to copy data from "WidgetPrices" into say "WidgetPr...
Comparing tables with different names
Is it possible to compare tables which are logically similar but have different table names using Data Compare 7.1. I've looked at the "Remap Objects" tab, but can't see how it can be done
Thanks Chris. Please close the call. There may have been a delay bewteen generating and executing the script. I will check details when I run this script next / comments
Thanks Chris. Please close the call. There may have been a delay bewteen generating and executing the script. I will check details when I run this script next
Amongst others I selected Include Identity Columns and Reseed Identity column. The script ran this as the last statement.
-- Reseed identity on [dbo].[tblEvent]
DBCC CHECKIDENT('[dbo].[tblEvent]', RESEED, 1014049)
GO
-- Reseed identity on [dbo].[tblContact]
DBCC CHECKIDENT('[dbo].[tblContact]', RESEED, 173013)
GO
I suspect the reseed values were wrong for some reason. I don't run this script very often. When I run it again I will check the identity reseed values before I run the script / comments
Amongst others I selected Include Identity Columns and Reseed Identity column. The script ran this as the last statement.
-- Reseed identity on [dbo].[tblEvent]
DBCC CHECKIDENT('[dbo].[tblEvent]',...
IDENTITY field corrupts after INSERT
Probably a SQL Server 2005 bug rather than Redgate, but after running a simple insert query generated by Data Compare on a table with an identity field, no new records can be inserted because the I...