Monday, March 19, 2012

Deploying SQL Server 2000 Developer Edition

Hi All,
Is it possible to use SQL Server 2000 Developer Edition for development and then deploy the database on MSDE?
Regards.
Yes
"sm" wrote:

> Hi All,
> Is it possible to use SQL Server 2000 Developer Edition for development and then deploy the database on MSDE?
> Regards.
|||backup the DB on your Development Server and restore to the MSDE machine
or
sp_detachdb the DB on your Development Server and then sp_attachdb on the
MSDE machine
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Andras Jakus" <AndrasJakus@.discussions.microsoft.com> wrote in message
news:EDE37FB7-2D1F-4255-9C37-D414518CB3ED@.microsoft.com...[vbcol=seagreen]
> Yes
> "sm" wrote:
and then deploy the database on MSDE?[vbcol=seagreen]

No comments:

Post a Comment