Comments
Sort by recent activity
Thanks Chris for your prompt response.
I shall be waiting for your your answers for my my other question (question2).
Thanks
Srikmr / comments
Thanks Chris for your prompt response.
I shall be waiting for your your answers for my my other question (question2).
Thanks
Srikmr
Here is the proble we are facing.
As i said in my earlier post we are having a sql_variant data type and it stores a DateTime value sometimes.
DATABASE 1 (DB1):
In table1 of DB1 we have few rows which have a date time value in this column (say the column name be DESCRIPTION which is of data type Sql_variant).
When i used the SELECT statement in Sql-Server Mgmt Studio i get the out put as below:
Query is: SELECT ID, DESCRIPTION from TABLE1
Result is like: 1, 2006-03-07 11:44:02.000
I can see that DESCRIPTION data is stored in the DB1 with a value of 2006-03-07 11:44:02.000
DATABASE2 (DB2):
In Table1 of DB2, we have a similar row.
I queried again for the data in Sql-Server Mgmt Studio, and i got the same result.
Query is: SELECT ID, DESCRIPTION from TABLE1
Result is like: 1, 2006-03-07 11:44:02.000
here too,
I can see that DESCRIPTION date is stored in the DB2 with a value of 2006-03-07 11:44:02.000
NOW I RUN THE SQLCompare against these two and get the result as they are not same. I have tried it using the UI and also the toolkit. Here is the output:
svValue 3/7/2006 11:44:02 AM <> 2006-03-07 11:44:02:000 The strange thing what i observed is:
1) The SqlDataCompare was showing the value from DB1 as
3/7/2006 11:44:02 AM instead of showing 2006-03-07 11:44:02.000
2) Surprisingly, The data from DB2 was showing as it is. i.e 2006-03-07 11:44:02.000 (which is as expected).
I wonder why SqlDataCompare is behaving in a different way while showing the data from DB1 and DB2.
If it were showing the same was as in DB1 then then its OK, but what i wonder is:
The same data is being shown differently from two similar rows of 2 databases.
Can you plese suggest a solution to overcome this problem. We need this to be solved very soon for our project.
Regards
Srikmr / comments
Here is the proble we are facing.
As i said in my earlier post we are having a sql_variant data type and it stores a DateTime value sometimes.
DATABASE 1 (DB1):
In table1 of DB1 we have few rows ...