Hi Jeff,

I do this all of the time. I have SQL 2000 Developer on my desktop and my clients have MSDE. I just do a backup from one and a restore to the other. It works without a problem.

I use DbaMgr2K on the client MSDE machines so I have a visual interface. http://www.asql.biz/DbaMgr/DownLoad2k.shtm is the link.

HTH,

TFISHER

>For development purposes I have MS SQL 2000 Developers Edition installed on my laptop. Can I use this to develop applications that will use MSDE when in production? If so how do I move a database from SQL 2000 to MSDE?