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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server 2005 to SQL Express 2005

Author  Topic 

MCas86
Starting Member

2 Posts

Posted - 2010-04-15 : 10:11:44
Is there a way to copy the database from SQL Server 2005 to SQL Express 2005? I'm finishing my degree and have a presentation coming up. I would like to be able to basically take the database with me so I can show what I've been doing. Thanks.

Sachin.Nand

2937 Posts

Posted - 2010-04-15 : 10:13:15
What you mean by "SQL Server 2005 to SQL Express 2005" ?

PBUH
Go to Top of Page

MCas86
Starting Member

2 Posts

Posted - 2010-04-15 : 10:14:39
The database is on the server and I want it on my laptop.
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2010-04-15 : 10:17:36
Yes u can.Just you need to take the backup from source database & restore on to the destination database.
More info can be found here http://msdn.microsoft.com/en-us/library/ms177429.aspx

PBUH
Go to Top of Page
   

- Advertisement -