SQL 2000 Database reports

Question

SQL 2000 Database reports

Ed7

SSCrazy Eights

Points: 8519
More actions
August 8, 2008 at 9:31 am

#126916

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 1

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.

Jeremy Brown SSCarpal Tunnel Points: 4223 More actions · Answer 2

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.

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 3

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.

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 4

SQLORACLE,

Can you direct me to the scripts?

I only use:

Select count (*) from table_name with (NOLOCK);

go

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 5

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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 6

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.