Re: How to upgrade MSDE databases to SQL Server Databases
From: shawnk (shawnk_at_discussions.microsoft.com)
Date: 02/03/05
- Next message: shawnk: "RE: How to configure WSS to use SQL server instead of MSDE"
- Previous message: Mike Walsh: "Re: Error after website restore"
- In reply to: Todd Klindt: "Re: How to upgrade MSDE databases to SQL Server Databases"
- Next in thread: Paul: "Re: How to upgrade MSDE databases to SQL Server Databases"
- Reply: Paul: "Re: How to upgrade MSDE databases to SQL Server Databases"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 3 Feb 2005 08:11:07 -0800
Todd,
I think this is what we will have to do as well :-)
First however we are going to permute the (1) install sequence on a 'web
farm' parameter and then (2) permute a server target on the WSS Web Admin
interface.
We are also going to search for a good tool to list all cross-platform
installed DB technoliges in the hope of one that can tell the difference
between Microsoft Access, MSDE, SQL Server Express and SQL Server databases.
Hopefully it will sense MYSQL, Oracle and other major platforms as well.
I'll post here on the results of our tool search to let everyone know if we
find anything.
Thanks for your input. We'll try this solution path after exhausting the
current solutions paths on our 'stack' :-)
"Todd Klindt" wrote:
> 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
>
>
>
- Next message: shawnk: "RE: How to configure WSS to use SQL server instead of MSDE"
- Previous message: Mike Walsh: "Re: Error after website restore"
- In reply to: Todd Klindt: "Re: How to upgrade MSDE databases to SQL Server Databases"
- Next in thread: Paul: "Re: How to upgrade MSDE databases to SQL Server Databases"
- Reply: Paul: "Re: How to upgrade MSDE databases to SQL Server Databases"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
