upgrade to sql 2005

[swoodring]

We had the server our SQL 2000 db were on on fail. It doesn't look like we can get that server up an running quickly. So we plan on getting a new server for it. But temporarily we have another server that currently has SQL 2005 on it and installed. So I would like to restore db from tape and move it to the 2005 server. Can I just restore it to the 2005 server from tape? Will that work? any suggestions would be appreciated.

Stacy

 

[ptheriault]

YEs you can, but you won't be able to go back to 2000 once the database has been restored to 2005. Keep in mind if you haven't tested this db in 2005 you may run into some compatability problems.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[swoodring]

We have not tested it yet. WE planned on upgrading later this year. What type of db incapabilities exist between 2000 and 2005? Our db is used for datawarehousing. Basically we load up db from our as/400 every night with the transactions/data for the day vis DTS. Then reports are queried off of the db via business objects.

Stacy

 

[ptheriault]

Well DTS no longer exists in 2005. You would have to import your DTS packages and save them as SSIS packages. There are many differences between DTS and SSIS. You would have to import your packages on at a time and see which ones need to be updated.

- Paul

- If at first you don't succeed, find out if the loser gets anything.