November 13, 2008 at 9:22 am
I'm new to SQL Server Express and I'm looking for an efficient way to export a database (includes stored procedures, functions) I have developed on my computer. I need to export it to a CD or DVD and install it at a another site who is running SQL Server 2005. Is this the best way to accomplish this from Managment Studio Express:
- right click on database > Tasks > Back Up
- burn the .bak file to a CD or DVD
- Restore the database from the .bak file on CD at the other location
Thanks
November 13, 2008 at 11:21 am
Hi,
That sounds like a perfectly sound method to do it. If you don't mind me asking; why is it that you have doubts about it?
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 13, 2008 at 11:28 am
Thanks Elisabeth. I wasn't sure if this method would capture my stored procedures and functions along with all of the table data.
November 17, 2008 at 12:40 pm
I wasn't able to restore a database in SQL Server 2000 that was orignally created and backed-up in SQL Server Express. A google search indicated that this is because SQL Server is not backwards compatible. Will I have any problems creating a backup in Express and restoring it in SQL Server 2005 at another location?
Thanks
November 17, 2008 at 1:42 pm
Hi,
I thought you said you wanted to restore in 2005? Anyway, no, you can't restore a 2005 database in 2000, but the other way around is OK.
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply