Mohammad:

As long as clients data is in SQL Server 2000 database tables, it is easy to migrate data from SQL Server 2000 to SQL Server 2008 using SSIS. You might want to create database and database objects in SQL Server 2008 that has compatible data types and other functions. Once you take care of this, you should be able to transfer data from SQL Server 2000 to SQL Server 2008. I have done this many many times and it should be very easy once you create tables in SQL Server 2008. One thing to make a note is, if there are lot of stored procedures, views, triggers, etc, you need to change the data types and functions compatible to SQL Server 2008.

Hope this helps to get you started. Let me know if you need further assistance.

Thanks,

Abi Chapagai

I believe the first part of the question is whether the web services you created for accessing data from SQL Server 2000 database will work for SQL Server 2008 or not. The answer is YES in most cases. I am not able to think of a scenario where it will break under SQL Server 2008, unless you use some discontinued features, which is not very likely.

I did not fully understand the second part of the question. As Abi has mentioned, if you are trying to pull data from multiple locations, it may be worth taking a look at SQL Server Integration Services (SSIS) which is one of the great ETL tools.