Re: Move a MSDE to SQL 2000

From: Eduardo Crespo (crespo_santamaria_at_NOSPAMhotmail.com)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 17:42:43 +0100

Thanks a lot Jacco

"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid>
escribió en el mensaje news:Om2zaxw0EHA.3120@TK2MSFTNGP12.phx.gbl...
> 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: Clarification:URGENT DB RESTORE INFO STILL REQUIRED
    ... I was wondering if anyone new if it was possible to restore a Database that was Backed up by SQL Server 2000 developer edition, into an Access 2002 Project that is CONNECTED TO A CURRENT VERSION OF MSDE. ...
    (microsoft.public.sqlserver.dts)
  • 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: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • 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: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... want to run sp_updatestats after the restore or attach as well. ... >>There is a lot more that can go wrong with the wizard ... > SQL Server Databases ... >>Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.setup)