.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

sql server 2008 express edition import export wizard usage

Posted By: jyothi     Posted Date: November 05, 2010    Points:2   Category :Sql Server
hi all

i created one windows application in c#.net and sqlserver2008. i have to give setup of application and database to the client. in client system there is no .net framework and sqlserver2008. so i installed sqlserver2008 express edition and .net framework 3.5 sp1 in client system. i imported database from flat file through import and export wizard of sqlexpress 2008 in client system.

but i am unable to connect that database.
is this correct process? if not please suggest the correct process


thanks in advance.


jyothi

Responses
Author: Dhiraj Ranka             
Posted Date: November 08, 2010     Points: 5   

If you have database on your system, them you can generate script for entire database including all or selected tables, views and stored procedures.

Right click on database in SQL Server Management Studio -> Tasks -> Generate Scripts

Follow this simple wizard and at end it will give you option to save it in a file

Browse for file location and use the same .sql file to create database at client side

I know its dirty way of doing it, but its one of the options

Others

1) Integrate this database creation in your application
2) Attach .mdf and/or .ldf file at client side (again dirty way)
3) Make database connection form in your application and use method 1).

Hope this helps

Hope this helps.

Thanks & Regards,
Dhiraj Ranka
http://www.twitter.com/dhirajranka | http://www.dhirajranka.com


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