?
Solved

Upgrate SQL MSDE 2000 to SQL 2000 enterprise edition

Posted on 2011-03-23
1
Medium Priority
?
272 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 81

Accepted Solution

by:
arnold earned 2000 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

850 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