Re: How to upgrade MSDE databases to SQL Server Databases

From: Todd Klindt (usenet_at_klindt.org)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 09:19:45 -0600

I've tried a couple of things in the past and not had good luck. At this
point if I want to move a WSS site from MSDE to SQL I back the site up
STSADM, point WSS at the SQL install and restore the site with STSADM. It's
been much nicer to me than any other method.

tk
"shawnk" <shawnk@discussions.microsoft.com> wrote in message
news:D902B947-6D0D-45E5-B1D6-49B69556671E@microsoft.com...
> We need to be able to manage WSS databases.
>
> MS Access databases can be 'up graded' using an 'up grade wizard' and make
> them SQL databases.
>
> Is there an 'up grade wizard' for MSDE databases that can upgrade them to
> SQL Server databases?
>
> We need to review Biztalk server but are being held up by all the WSS
> issues
> related to its use of MSDE databases.
>
> Thanks much in advance.
>
> Shawnk

Relevant Pages

  • RE: How to configure WSS to use SQL server instead of MSDE
    ... This is why, in this post, I wanted to focus on only WSS features. ... Apparently WSS DOES NOT SUPPORT SQL Server since it has no tool (that we ... >>MSDE databases for its configuration and content ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: MSDE - list databases, describe tables, migrate from Access?
    ... Go into SQL prompt using ... > I am new to SQL Server but have been using Access for a while. ... > installed MSDE to evaluate it for use in small business ... > I can't see how to get the list of databases, tables, and columns that I ...
    (microsoft.public.sqlserver.server)
  • Re: MSDE or SQL2000
    ... special version of MSDE 2.0 called WMSDE which does not ... The main problem with WMSDE and WSS is that you can't sort as this needs SQL ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: WSS - SQL2000 Install Problem
    ... using MSDE for WSS and SQL for whatever else? ... As Stan said why would you want to - WMSDE offers nothing that SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • GUI utility for MSDE with DTS
    ... I know there's plenty of MSDE managment utilities out there to help us with ... a nice GUI for MSDE. ... What I like about using Enterprise Manager which comes with the SQL Server ... I need to import data from other databases on my workstation via non-SQL ...
    (microsoft.public.sqlserver.msde)