TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ash Sharma
NA
11
489
Source Control Data Inserts using SSDT
Feb 27 2018 5:30 PM
I have a website called "ReportDownloads" which shows a list of reports that Buisness can download for decision making.
As shown here, the table ReportDownloads look like this:
ReportName
SQLQuery
DailyReport
SELECT * FROM....
When the user click on any of the report, the report execute a SQL Query as written in SQLQuery column to build that report.
The requirement is if we want to edit that report, we need to change the SQLQuery, but lets say with multiple release of the same report, we don't want to insert multiple rows for same ReportName, we always want to have one row with most updated SQLQuery. But we do want to keep track of the changes made in each SQLQuery. This I believe can be done using Post Deployment Scripts with SSDT and we would be able to source control our all SQLScripts.
I am having hard time understanding PostDeployement Script.
Can someone please explain, how it can be achieved in Visual Studio 2015 with SQL Server Version 2008
Reply
Answers (
5
)
date time convert
how can get data from two tables?