Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kenny
Starting Member
1 Post |
 Posted - 2005-12-14 : 05:58:36
|
| Hi thereI'm pretty new to this SQL server thingie, and I have this question..How do I copy a database from SQL Server 2000 to my local SQL Server Express? I have done this between 2000 before, but the manager for the express edition doesn't seem to have the copy task..I really need to do this, since I have to work with a databse locally on my machine when developing...I can't register my express server in the enterprise manager on the machine from which I need to copy the databse.. Seems to be a version incompability problem?Does anyone have a solution for this?Thanks,Kenny |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-12-14 : 14:14:12
|
| Hi Kenny,Couple of points to start:1) the copy task isn't there in Express manager because Express does not include the underlying SSIS (2005 version of DTS) component needed for it.2) SQL 2000 Enterprise Manager does not support connecting to SQL Server 2005What you need to do it copy the database files to the local Express instance yourself. You can do this by:1) cleanly shutting down the database in question (either detach it or shutdown the SQL instance)2) use Windows to copy/move the database files to the machine where Express is installed3) attach the database to the Express instance. It will be upgraded to the SQL Server 2005 formatNote that you will not then be able to re-attach it to the SQL Server 2000 instance - upgrade is a one way operation and previous versions of SQL Server do not support accessing later version formats.RegardsPaul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
copy database from server 2000 to express