refresh after synchronization
Oleg
Posts: 83
I do synchronization, refresh and the same objects are different again.
Difference is in whitespaces. But as for me after sync objects must be equal.
Difference is in whitespaces. But as for me after sync objects must be equal.
This discussion has been closed.
Comments
This sounds like an issue we are investigating. Is the white space problem one new line at the end of an object on a SQL2005 database?
Regards,
Jonathan
-Project Manager
-Red Gate Software Ltd
its the first object (end of proc)
1(2005)
if @trancount>0
begin
if @status=0
commit tran
else
rollback tran
end
end
GO
2 (2000)
if @trancount>0
begin
if @status=0
commit tran
else
rollback tran
end
yok, kyrdyk
end
GO
end of 2
The difference is here
end
<
GO
Regards,
Oleg.
Hi Oleg,
as Jon mentioned there is an issue with tailing newlines when migrating from 2000 to 2005. This is because of the way 2005 "eats" some newlines. At the moment the only way around it is to set "ignore whitespace" to on, but we are looking into this bug. Note that 2000 to 2000 migration, as well as 2005 to 2005 migration should work.
Regards,
Andras
Red Gate Software Ltd.