Activity overview
Latest activity by ccurcillo
ccurcillo wrote:
smiller wrote:
I generated a table script from SQL Server 2008 and compared to a snapshot. A field is defined as DATE in the script and DB, but shows as [sys].[date] in the script in the comparision report.
How can the conversion to [sys].[date] be prevented, or ignored when generating the comparision report?
Thanks.
On your data source screen, select "comparison settings". make sure that the SQL versions are in sync. I am guessing that yours is still set to 2005 (default), which does not know what a "date" data type is. / comments
ccurcillo wrote:
smiller wrote:
I generated a table script from SQL Server 2008 and compared to a snapshot. A field is defined as DATE in the script and DB, but shows as [sys].[date] in the ...
smiller wrote:
I generated a table script from SQL Server 2008 and compared to a snapshot. A field is defined as DATE in the script and DB, but shows as [sys].[date] in the script in the comparision report.
How can the conversion to [sys].[date] be prevented, or ignored when generating the comparision report?
Thanks.
...having same issue. any solution? / comments
smiller wrote:
I generated a table script from SQL Server 2008 and compared to a snapshot. A field is defined as DATE in the script and DB, but shows as [sys].[date] in the script in the compar...