.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Eminent IT

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Copying Data from SQL Server 2008 to SQL Express

Posted By: Sruthi Keerthi     Posted Date: September 24, 2009    Points:2   Category :Sql Server

I would like to copy a database (tables, it's data, stored procs & views) from SQL Server 2008 database to SQL Express. Is it possible? If so, would you please let me know how to do it? When I tried, it is giving some error.

Please note that I have only few records in SQL Server 2008 database tables.

Thanks and Regards..
Shruthi Keerthi..

Author: Venkat             
Posted Date: September 24, 2009     Points: 5   

I suggest you to use backup/restore functionality instead of Wizard..Take the backup of the SQL Server 2008 database and restore in SQL Express.

Mark As Answer if this solve your problem
Warm Regards,

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend