Copy schema and data from sqls2k to sqls2k5express

Hello,
I am a newbie on this subject.
How do I move a database in SQL Server 2000 to SQL Server 2005 Express?
How do I manage SQL Server 2005 Express? Can that be done in VS 2005
Professional.
Thank you,
dbuchananHi
Backup and restore or DB attach and detach.
You can use Microsoft SQL Server Management Studio Express - Community
Technology Preview (CTP) November 2005 to manage the SQL Express instance.
http://www.microsoft.com/downloads/...&displaylang=en
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"dbuchanan" <dbuchanan52@.hotmail.com> wrote in message
news:1134435181.280719.206900@.g49g2000cwa.googlegroups.com...
> Hello,
> I am a newbie on this subject.
> How do I move a database in SQL Server 2000 to SQL Server 2005 Express?
> How do I manage SQL Server 2005 Express? Can that be done in VS 2005
> Professional.
> Thank you,
> dbuchanan
>|||Mike,
My previous question I asked for my target machine.
I have MSDN Professional subscription and I have SQL Server 2005
installed, but I don't know how to get started with 2005
1.) Where are the databases. I selected the option to install all
sample databases.
2.) Where also is the equivalent to Enterprise Manager, Query Analyser
for 2005 and the other services. I did a complete install!
Under SQL Configuration Manager / SQL Server 2005 Services I can see a
list of everything I would be interested in finding. I can see the
state, start mode, etc. of these services but where to I get access to
them'''?
How do I get started with SQL Server 2005? Does it have to be made into
such a mystery'
Thank you,
dbuchanan|||The new weapon of choice is the SQL Server Management Studio (SSMS). And whe
n
I say 'choice' one really has no other choice. :)
But you might start with the SQL Server Cofiguration Manager and the SQL
Server Surface Area Configuration to enable access to the server, or better
yet - Books Online, What's new.
ML
http://milambda.blogspot.com/|||ML,
1.) I did a full install. Does SQL Server Management Studio install
with SQL Server 2005? I cannot find it.
2.) Where is Books Online? The Icon that looks like it from SQL Server
Configuration Manager is really MMC help and a search of "What's New"
says nothing about SQL Server 2005.
The Help from SQL Server 2005 Serface Area Configuration is SQL Server
Setup help and a search of "What's New" is whats net for setup.
For SQL Server 2005 from the start menu there is no shortcut to Books
Online like there is for SQL Server 2000.
Where is Books Online?
Why is SQL Server 2005 services so hard to find?
dbuchanan|||Are you using SQL 2005 Express? Well, there are no visual tools available in
the SQL Express set up. SQL Server Management Studio Express is available as
a separate download. The same goes for Books Online.
Go to http://www.microsoft.com/downloads
Help (Books Online) is also avaliable on-line:
http://msdn2.microsoft.com/default.aspx
ML
http://milambda.blogspot.com/|||ML,
No I am not using SQL 2005 Express.
I have done a *complete* install of *SQL Server 2005 Developer
Edition*. I am a MSDN *Professional* Subscriber.
Where is Books Online? Were are the SQL Server Management Studio?
dbuchanan|||
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Backup and restore or DB attach and detach.
>
I have tried to do this. SQL2005 Express does not support these featurs for
SQL 2000 databases. If you are sucessful please let us all know! I would
like to distribute a SQL2000 database to clients running SQL2005 express.
After much research I am still trying to get the database into SQL2005
Express. Any help would be very much appreciated!|||> If you are sucessful please let us all know!
I detached a SQL 2000 database using sp_detach_db and successfully attached
the files to a SQL 2005 with CREATE DATABASE ... FOR ATTACH:
CREATE DATABASE MyDatabase
ON(
NAME='MyDatabase',
FILENAME='C:\DataFiles\MyDatabase_Data.mdf')
LOG ON(
NAME='MyDatabase_Log',
FILENAME='C:\LogFiles\MyDatabase_Log.ldf')
FOR ATTACH
Hope this helps.
Dan Guzman
SQL Server MVP
"HVG" <HVG@.discussions.microsoft.com> wrote in message
news:D5F8E749-D268-4B4D-870E-7B7089195D82@.microsoft.com...
>
> "Mike Epprecht (SQL MVP)" wrote:
>
> I have tried to do this. SQL2005 Express does not support these featurs
> for
> SQL 2000 databases. If you are sucessful please let us all know! I would
> like to distribute a SQL2000 database to clients running SQL2005 express.
> After much research I am still trying to get the database into SQL2005
> Express. Any help would be very much appreciated!