| Author |
SQL Server 2000 v/s 2005 compatibility
|
|
|
| We have a huge database on SQL 2005 and there are hundreds of users having
the copy of this datbase on SQL 2000
We used to provide backup dump file for them to restore
Now with SQL 2005, I have read that we can not restore a dump from 2005 on
to 2000
Is there any alternate method or third party tools that can do a restore
onto 2000 from 2005. Export and import of individual tables is very time
consuming and we do not want to use it as it has to be done almost daily
basis.
Kiran
| |
| Allan Mitchell 2006-01-30, 8:24 pm |
| Hello Kiran,
You will not be able to do a RESTORE from 2005 to 2000. I know of no way
other than doing as you have suggested to make this happen.
Allan
> We have a huge database on SQL 2005 and there are hundreds of users
> having the copy of this datbase on SQL 2000
>
> We used to provide backup dump file for them to restore
> Now with SQL 2005, I have read that we can not restore a dump from
> 2005 on
> to 2000
> Is there any alternate method or third party tools that can do a
> restore onto 2000 from 2005. Export and import of individual tables is
> very time consuming and we do not want to use it as it has to be done
> almost daily basis.
>
> Kiran
>
| |
|
| Hi Allan Thanks for the reply
It would be very very helpful if Microsoft could come out with a way to
support 2000 clients.
Kiran
"Allan Mitchell" wrote:
> Hello Kiran,
>
>
> You will not be able to do a RESTORE from 2005 to 2000. I know of no way
> other than doing as you have suggested to make this happen.
>
>
> Allan
>
>
>
>
|
|
|
|