Solved

move sql database into asp.net solution...

Posted on 2014-07-30
4
172 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now