|
|
|
SSC Veteran
 
Group: General Forum Members
Last Login: Tuesday, June 30, 2009 2:29 PM
Points: 251,
Visits: 558
|
|
Hello Room,
I need to compare between MSSQL Server 2005 and 2000 database tables.
MSSQLServer 2005 provided a reports function that I can run.
How can I run a report on SQL 2000?
Any advice and help are very appreciated.
Regards,
Edwin
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 6:36 PM
Points: 1,325,
Visits: 966
|
|
| SQL Server reports is a new function in SQL 2005. You need to develop your own scripts or use the third party tool to generate reports in SQL 2000.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, June 18, 2009 9:24 AM
Points: 183,
Visits: 158
|
|
Compare as in how? Are you comparing the data or the table structures?
In either case, you can use tools from RedGate or use Microsoft Visual Studio Team Edition for Database Developers. Both contain tools that will allow you to do quick table and data comparisons.
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, June 30, 2009 2:29 PM
Points: 251,
Visits: 558
|
|
I compare the data. The RedGate tool did not work out and I already tried it out.
Our database environments are setup very unique.
SQL 2000 and 2005 are located in different network segment.
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, June 30, 2009 2:29 PM
Points: 251,
Visits: 558
|
|
SQLORACLE,
Can you direct me to the scripts?
I only use:
Select count (*) from table_name with (NOLOCK);
go
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Today @ 11:40 AM
Points: 2,071,
Visits: 3,429
|
|
Edwin (8/8/2008)
I compare the data. The RedGate tool did not work out and I already tried it out.
Our database environments are setup very unique.
SQL 2000 and 2005 are located in different network segment.
Red-Gate's SQL Data Compare tool sounds exactly like what you want. But, just saying it did not work out does not help us help you. What does it mean when you say it did not work out?
When you say you need to compare the data - what needs to be compared? Are you just looking at comparing the row counts?
Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 6:36 PM
Points: 1,325,
Visits: 966
|
|
What information would you like to include in your reports?
If you would like to get the number of rows in each table only, you may try to use the system table, sys.sysindexes, where you can get number of rows directly.
|
|
|
|
