| Author |
Message |
Le9569
Guest
|
 Posted:
Wed Jan 12, 2005 5:13 am Post subject:
Moving from MSDE to MS SQL server 2000 |
|
|
Hello all,
We are planning to have a sharepoint deploying in a small group. We don't
want to buy MS SQL server right away. Instead, we use MSDN for now. Later,
we will migrate database from MSDE to MS SQL server. Is it possible. If so,
would you please help me find the how-to articles on this?
Thank you much.
le9569 |
|
| Back to top |
|
 |
Mike Walsh
Guest
|
| Posted:
Wed Jan 12, 2005 11:25 am Post subject:
Re: Moving from MSDE to MS SQL server 2000 |
|
|
The easiest way is just to insert the SQL Server 2K CD in the CD drive and
select (when given the option) upgrade. (followed later by SQL Server 2K SP
3A).
This naturally upgrades a single server installation in site.
You can also look at the Admin Guide. Backup and Restore looks suitable.
But to answer your main question, yes, it is possible.
Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.
"Le9569" <Le9569@discussions.microsoft.com> wrote in message
news:DBEFC963-07A2-46A6-8EF4-E7F27EAD330C@microsoft.com...
| Quote: | Hello all,
We are planning to have a sharepoint deploying in a small group. We don't
want to buy MS SQL server right away. Instead, we use MSDN for now.
Later,
we will migrate database from MSDE to MS SQL server. Is it possible. If
so,
would you please help me find the how-to articles on this?
Thank you much.
le9569 |
|
|
| Back to top |
|
|
Le9569
Guest
|
| Posted:
Wed Jan 12, 2005 2:21 pm Post subject:
Re: Moving from MSDE to MS SQL server 2000 |
|
|
Great info. Thanks for the push :)
"Mike Walsh" wrote:
| Quote: | The easiest way is just to insert the SQL Server 2K CD in the CD drive and
select (when given the option) upgrade. (followed later by SQL Server 2K SP
3A).
This naturally upgrades a single server installation in site.
You can also look at the Admin Guide. Backup and Restore looks suitable.
But to answer your main question, yes, it is possible.
Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.
"Le9569" <Le9569@discussions.microsoft.com> wrote in message
news:DBEFC963-07A2-46A6-8EF4-E7F27EAD330C@microsoft.com...
Hello all,
We are planning to have a sharepoint deploying in a small group. We don't
want to buy MS SQL server right away. Instead, we use MSDN for now.
Later,
we will migrate database from MSDE to MS SQL server. Is it possible. If
so,
would you please help me find the how-to articles on this?
Thank you much.
le9569
|
|
|
| Back to top |
|
|
Todd Klindt
Guest
|
| Posted:
Thu Jan 13, 2005 5:29 am Post subject:
Re: Moving from MSDE to MS SQL server 2000 |
|
|
You can also use STSADM to back the site up and then restore it after you
install SQL. Mike's idea is best if you're going to install SQL on the same
machine that's running IIS. If you install SQL on another machine, it seems
easiest to do the backup and restore.
tk
"Le9569" <Le9569@discussions.microsoft.com> wrote in message
news:94B40813-500B-4D77-83A9-E3080F5CFD34@microsoft.com...
| Quote: | Great info. Thanks for the push :)
"Mike Walsh" wrote:
The easiest way is just to insert the SQL Server 2K CD in the CD drive
and
select (when given the option) upgrade. (followed later by SQL Server 2K
SP
3A).
This naturally upgrades a single server installation in site.
You can also look at the Admin Guide. Backup and Restore looks suitable.
But to answer your main question, yes, it is possible.
Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.
"Le9569" <Le9569@discussions.microsoft.com> wrote in message
news:DBEFC963-07A2-46A6-8EF4-E7F27EAD330C@microsoft.com...
Hello all,
We are planning to have a sharepoint deploying in a small group. We
don't
want to buy MS SQL server right away. Instead, we use MSDN for now.
Later,
we will migrate database from MSDE to MS SQL server. Is it possible.
If
so,
would you please help me find the how-to articles on this?
Thank you much.
le9569
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in