Re: Move a MSDE to SQL 2000

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 16:32:29 -0000

You can just make a backup of the database on MSDE and restore that on the
SQL Server. That is all there is to it, assuming MSDE and SQL Server are
both the same version (i.e. both 7 or both 2000). 

-- 
Jacco Schalkwijk
SQL Server MVP
"Eduardo Crespo" <crespo_santamaria@NOSPAMhotmail.com> wrote in message 
news:eP%23Fokw0EHA.1196@TK2MSFTNGP15.phx.gbl...
> Hi
>
> My problem is that I have a MSDE database in one server and I want to move 
> it to an SQL Server in another server. Can anyone tell me what procedure 
> do I have to follow?
>
> Thanks in advance
>
>
>

Relevant Pages

  • Re: msde2000
    ... Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, ... As for it being better than MS-Access, the answer to that is probable yes, ... MOST other database DO NOT. ...
    (microsoft.public.vc.mfc)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Re: Theres a new Borland Delphi directions survey up
    ... Choosing and Using MSDE 2000 as the Database Engine for Your Application ... The Microsoft SQL Server 2000 Desktop Engine is an alternative ... database engine in Microsoft Access 2002 which enables software developers ...
    (borland.public.delphi.non-technical)
  • Re: msde2000
    ... MSDE is the desktop version of SQL server. ... Basically, Access is a desktop application, MSDE is a database backend. ... go through OLEDB, so theoretically therefore it's arguably the fastest ...
    (microsoft.public.vc.language)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)