How to manage large scale Visual Studio Database Projects?
I've been using SQL Server for quite sometime and I have management problems about my large scale projects.
- best practices for large applications such as project structure, how to manage scripts ...
- tools (better tools than default VS IntelliSense)
I was wondering how others manage their large scale projects.
sql-server visual-studio ssdt edited Nov 11 at 20:55
marc_s
570k12811021250
asked Nov 11 at 20:04
Sahandevs
65
add a comment |
I've been using SQL Server for quite sometime and I have management problems about my large scale projects.
- best practices for large applications such as project structure, how to manage scripts ...
- tools (better tools than default VS IntelliSense)
I was wondering how others manage their large scale projects.
sql-server visual-studio ssdt edited Nov 11 at 20:55
marc_s
570k12811021250
asked Nov 11 at 20:04
Sahandevs
65
What problems are you having managing your large scale projects? What problems with managing scripts? What tools are lacking?
– Joe
Nov 11 at 20:57
Off-topic for SO.
– SMor
Nov 11 at 20:59
add a comment |
I've been using SQL Server for quite sometime and I have management problems about my large scale projects.
- best practices for large applications such as project structure, how to manage scripts ...
- tools (better tools than default VS IntelliSense)
I was wondering how others manage their large scale projects.
sql-server visual-studio ssdt edited Nov 11 at 20:55
marc_s
570k12811021250
asked Nov 11 at 20:04
Sahandevs
65
I've been using SQL Server for quite sometime and I have management problems about my large scale projects.
- best practices for large applications such as project structure, how to manage scripts ...
- tools (better tools than default VS IntelliSense)
I was wondering how others manage their large scale projects.
sql-server visual-studio ssdt sql-server visual-studio ssdt edited Nov 11 at 20:55
marc_s
570k12811021250
asked Nov 11 at 20:04
Sahandevs
65
edited Nov 11 at 20:55
marc_s
570k12811021250
asked Nov 11 at 20:04
Sahandevs
65
edited Nov 11 at 20:55
marc_s
570k12811021250
edited Nov 11 at 20:55
marc_s
570k12811021250
edited Nov 11 at 20:55
marc_s
570k12811021250
570k12811021250
asked Nov 11 at 20:04
Sahandevs
65
asked Nov 11 at 20:04
Sahandevs
65
asked Nov 11 at 20:04
Sahandevs
65
65
What problems are you having managing your large scale projects? What problems with managing scripts? What tools are lacking?
– Joe
Nov 11 at 20:57
Off-topic for SO.
– SMor
Nov 11 at 20:59
add a comment |
What problems are you having managing your large scale projects? What problems with managing scripts? What tools are lacking?
– Joe
Nov 11 at 20:57
Off-topic for SO.
– SMor
Nov 11 at 20:59
What problems are you having managing your large scale projects? What problems with managing scripts? What tools are lacking?
– Joe
Nov 11 at 20:57
What problems are you having managing your large scale projects? What problems with managing scripts? What tools are lacking?
– Joe
Nov 11 at 20:57
Off-topic for SO.
– SMor
Nov 11 at 20:59
Off-topic for SO.
– SMor
Nov 11 at 20:59
add a comment |
1 Answer
1
active
oldest
votes
No so much clear about " I have management problems about my large scale projects", are you talking about how to organize the structure of the source code? Which tool do you use for this, from my experience, I can suggest you the use of Visual Studio + SSDT, this allows you to have once solution organized per Database, internally it will organize a snapshot, it means, a project which will be organized on common objects like tables, functions, stored procedures, etc. Another great benefit is the use of Dacpac technology that you can use for creating a new Database from scratch with the same structure on it was based on.
In Visual Studio 2017 you have some amazing RedGate tool included (free), but I believe that you can take advantage of VS per se, I have not had any problem in terms of productivity with the use of Visual Studio.
answered Nov 11 at 21:02
Geovanny Hernandez
1165
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53252715%2fhow-to-manage-large-scale-visual-studio-database-projects%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
No so much clear about " I have management problems about my large scale projects", are you talking about how to organize the structure of the source code? Which tool do you use for this, from my experience, I can suggest you the use of Visual Studio + SSDT, this allows you to have once solution organized per Database, internally it will organize a snapshot, it means, a project which will be organized on common objects like tables, functions, stored procedures, etc. Another great benefit is the use of Dacpac technology that you can use for creating a new Database from scratch with the same structure on it was based on.
In Visual Studio 2017 you have some amazing RedGate tool included (free), but I believe that you can take advantage of VS per se, I have not had any problem in terms of productivity with the use of Visual Studio.
answered Nov 11 at 21:02
Geovanny Hernandez
1165
add a comment |
No so much clear about " I have management problems about my large scale projects", are you talking about how to organize the structure of the source code? Which tool do you use for this, from my experience, I can suggest you the use of Visual Studio + SSDT, this allows you to have once solution organized per Database, internally it will organize a snapshot, it means, a project which will be organized on common objects like tables, functions, stored procedures, etc. Another great benefit is the use of Dacpac technology that you can use for creating a new Database from scratch with the same structure on it was based on.
In Visual Studio 2017 you have some amazing RedGate tool included (free), but I believe that you can take advantage of VS per se, I have not had any problem in terms of productivity with the use of Visual Studio.
answered Nov 11 at 21:02
Geovanny Hernandez
1165
add a comment |
No so much clear about " I have management problems about my large scale projects", are you talking about how to organize the structure of the source code? Which tool do you use for this, from my experience, I can suggest you the use of Visual Studio + SSDT, this allows you to have once solution organized per Database, internally it will organize a snapshot, it means, a project which will be organized on common objects like tables, functions, stored procedures, etc. Another great benefit is the use of Dacpac technology that you can use for creating a new Database from scratch with the same structure on it was based on.
In Visual Studio 2017 you have some amazing RedGate tool included (free), but I believe that you can take advantage of VS per se, I have not had any problem in terms of productivity with the use of Visual Studio.
answered Nov 11 at 21:02
Geovanny Hernandez
1165
No so much clear about " I have management problems about my large scale projects", are you talking about how to organize the structure of the source code? Which tool do you use for this, from my experience, I can suggest you the use of Visual Studio + SSDT, this allows you to have once solution organized per Database, internally it will organize a snapshot, it means, a project which will be organized on common objects like tables, functions, stored procedures, etc. Another great benefit is the use of Dacpac technology that you can use for creating a new Database from scratch with the same structure on it was based on.
In Visual Studio 2017 you have some amazing RedGate tool included (free), but I believe that you can take advantage of VS per se, I have not had any problem in terms of productivity with the use of Visual Studio.
answered Nov 11 at 21:02
Geovanny Hernandez
1165
answered Nov 11 at 21:02
Geovanny Hernandez
1165
answered Nov 11 at 21:02
Geovanny Hernandez
1165
answered Nov 11 at 21:02
Geovanny Hernandez
1165
1165
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53252715%2fhow-to-manage-large-scale-visual-studio-database-projects%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What problems are you having managing your large scale projects? What problems with managing scripts? What tools are lacking?
– Joe
Nov 11 at 20:57
Off-topic for SO.
– SMor
Nov 11 at 20:59