Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

move sql database into asp.net solution...

Posted on 2014-07-30
4
175 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 34

Author Closing Comment

by:Mike Eghtebas
ID: 40238294
Thank you.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Finding the IIS version 5 21
tempdb log keep growing 7 32
stress test workstation for SQL 2016 for CPU-specific evaluation 3 22
Change to file doesn't show up 16 50
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
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…

790 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