Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
sql server 2008 express edition import export wizard usage
November 05, 2010
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.
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
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,
To post reply
Related Questions Related Questions
Copying Data from SQL Server 2008 to SQL Express
Anybody have sqlserver2005 Express edition SP1
Upgrade from SQL Server 2000 to SQL Server 2008
Performing search on MS SQL Server 2008 database
Taking incremental backups from MS SQL Server 2008 Database
SQL Server 2008 - Table - Clarifications
How to install softwares on client computer from server computer in Visual Basic.Net 2008.
What is the use of Row Constructor in Sql Server 2008?
What are the new features that we have in Sql Server 2008?
how many nested levels are there in Sql Server 2008 for Stored Procedures?
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend