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


Top 5 Contributors of the Month
david stephan

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
.
Hi,

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..
.

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

HI,
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,
Venkat


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
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

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