Solved

move sql database into asp.net solution...

Posted on 2014-07-30
4
174 Views
Last Modified: 2014-08-03
I have small database working as back-end to my asp project. How can I include it with my asp project?

Does this mean it will be disconnected from the original database?

Basically, I want zip one file and send to someone else compare to making yet another backup copy of my sql server database. Does it work like that?

Thank you.
0
Comment
Question by:Mike Eghtebas
4 Comments
 
LVL 11

Assisted Solution

by:Joseph O'Loughlin
Joseph O'Loughlin earned 100 total points
ID: 40231125
Sorry there's no packaging of both the backend database and frontend website.
0
 
LVL 52

Assisted Solution

by:Carl Tawn
Carl Tawn earned 100 total points
ID: 40231183
I'm not quite clear on what it is you are wanting to do. However, you can add a database to the Data folder in your project and "attach" it at runtime, you could then deploy it as part of the project.
0
 
LVL 16

Accepted Solution

by:
Kalpesh Chhatrala earned 300 total points
ID: 40237478
1) You need to Create SQL Script from SQL Server Management Studio  OR Generate Backup of MSSQL Database.

2) Send this SQL Script / Backup file to some one else.

3) they need restore backup or need to run SQL server script in their MSSQL Server.

4) then they need to modify SQL server reference in your project.
0
 
LVL 33

Author Closing Comment

by:Mike Eghtebas
ID: 40238294
Thank you.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
imap mails 1 22
start a process from a service 3 21
Need to learn more about SecurityProtocolType.Tls12 3 28
Save ms data to server side. 19 42
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question