Hi,

Can anyone tell me how to export an SQL database to an MSDE engine? I'm trying to get this Windows 2003 server's MSDE populated with values from an existing SQL 2000 db but it's rejecting the .sql script I generated from the SQL 2000. Is there an easier way to do this other than going through the webadmin panel of the MSDE?

Many thanks!!!

Regards,
Marlon


Marlon Villarama

You can use the sql 2000 enterprise manager and connect to your MSDE Instance. Note: MSDE has a lot of limitation compared to full SQL 2000.

Make a backup of the SQL 2000 database and restore it to your MSDE instance.

Also post your script!

Jaime E. Maccou
Applications Analyst

Hi,

Thanks for the reply!

The sql script I was trying to import was just a regular generated SQL script from SQL 2000. One of its lines is:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Articles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Articles]
GO

However, I get the following error:

Line 1: Incorrect syntax near 'e'.
'.d.b.o.' is an invalid name because it contains a NULL character.
'.A.r.t.i.c.l.e.s.' is an invalid name because it contains a NULL character.

Has anyone encountered this error before? Any help would be greatly appreciated...

Many thanks!
Marlon




Marlon Villarama

try it this way

if exists (select * from dbo.sysobjects where id = object_id(N'[Articles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [articles]

and make sure to run it from the master database

GO

Jaime E. Maccou
Applications Analyst