MSDE to SQL 2000

What's the best way to get the data from the MSDE server
to the SQL 2000 server?
I've tried backing up and restoring from the SQL 2000
server, but I get "consistency errors". I ran DBCC
CHECKDB and MSDE DB was clean.
Then I tried to import the tables using EM, but am
getting errors.
Thanks,
DonDon wrote:
> What's the best way to get the data from the MSDE server
> to the SQL 2000 server?
> I've tried backing up and restoring from the SQL 2000
> server, but I get "consistency errors". I ran DBCC
> CHECKDB and MSDE DB was clean.
> Then I tried to import the tables using EM, but am
> getting errors.
I assume that "using EM" means creating and executing DTS data import/export
package using the wizard. What are the errors you get?
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||I guess you are trying to take across the system databases too... which is
why you are probably getting errors. you should only try to bring across the
user dbs in this scenario.
detach and reattach the dbs to the new server.
see also http://www.support.microsoft.com/?id=314546
Br,
Mark.
"Don" <ddachner@.hotmail.com> wrote in message
news:241601c3ffeb$03baff50$a601280a@.phx.gbl...
> What's the best way to get the data from the MSDE server
> to the SQL 2000 server?
> I've tried backing up and restoring from the SQL 2000
> server, but I get "consistency errors". I ran DBCC
> CHECKDB and MSDE DB was clean.
> Then I tried to import the tables using EM, but am
> getting errors.
> Thanks,
> Don
>