Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Port SQL Server 2005 Express database to SQL Server 2000

Posted on 2006-10-31
5
353 Views
Last Modified: 2008-01-09
I have a small website that was developed using SQL Server 2005 Express as the database. Now that it is being moved to a production enviroment I need to port the database to SQL Server 2000. Is there an easy way to do this?
0
Comment
Question by:BenEdwards
5 Comments
 
LVL 17

Accepted Solution

by:
HuyBD earned 250 total points
ID: 17848113
Try to use Import or Export function in administration
0
 
LVL 35

Assisted Solution

by:Raynard7
Raynard7 earned 250 total points
ID: 17848231
Hi,

What you want is is to have this posted in the microsoft sql area - however below may help you

http:Q_21682786.html "How can I move my database from SQL Server 2000 to SQL Server 2005 Express?"
http:Q_21935768.html "Connectivity issues between SQL 2000 and SQL Express 2005"
http:Q_21813699.html "Moving databases from SQL 2005 Express to SQL 2000"
http:Q_21745333.html "Convert MS SQL 2005 Express DB back to SQL 2000"



0
 

Author Comment

by:BenEdwards
ID: 18038005
fine to close. thanks, ben.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 4 178
MS Access - need to reduce row size 25 60
Optimize the query 5 43
mysql db 3 69
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

829 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