Moving SQL server to another

[Betray]

Hello,

ive tried a million ways to export objects+data from one server to another.
the MSSQL versions are differant. (the new location is sql2005). When i try to use DTS, i get major problems copy over.. infact it give me a error when trying to copy all objects.. ive tried everything! only way ive copied the tables and stored proc. is by generating scripts using server enterprise. Im still missing the data... i found one program called sql script builder which charges 190!!!!! insane. but anyways it did the job very well, except only 10 rows per table.. very limited on that. can anyone help? thank you!

[Delerna]

I'll be watching this thread with interest.
I assume you are migrating from SQL2000 to SQL2005.
Thats a task I will be engaged in, in the not too distant future.

[ck9663]

Can't you do a backup on the sql2000 and restore it sql2005?

-- CK

[Betray]

Can't you do a backup on the sql2000 and restore it sql2005?

-- CK

The backup files are stored over at the hosts server. I do not have access to these files.

[BHTanna]

Can't you use sp_attach_db ????

[Betray]

Can't you use sp_attach_db ????

im unaware of this function.
ive found a slow soloution that copied most of the data over, but 20 tables of data failed. not sure why? no error log