Solved

Upgrate SQL MSDE 2000 to SQL 2000 enterprise edition

Posted on 2011-03-23
1
263 Views
Last Modified: 2012-05-11
Hi All,
We are currently running a Microsoft SQL 2000 based  application, the db is MSDE 2000 release A that has synchronization with another MSDE 2000 remotely on a different location.(we managed to do that few years ago by installing only the enterprise manager of SQL 2000).
my question is:
can i uprate from the MSDE to 2000 enterprise without reconfigure the synchronization ? we would like to perform an uprate that will keep all the synchronization configuration.
thank you
0
Comment
Question by:activenet1
1 Comment
 
LVL 78

Accepted Solution

by:
arnold earned 500 total points
ID: 35205988
You should first backup the configuration just in case.  I think you can but, this is an older version of SQL server.
Are you talking about replication?
make sure you have a copy of the create scripts as well if you do not have it already.
You can never be too cautious.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query 5 44
Regarding Disk IO 3 49
Connect remotely to SQL Server DB without TCP/IP enabled? 2 36
Using datetime as triggers 2 23
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question