Attaching several mdf files to a SQL Server instance or extract data and save it to a new database
We have several engineering projects whose data is finally stored in a .mdf SQL Server database file. I now want to centralize all this engineering data and create reports about the different projects.
What would you recommend? Should I attach all the .mdf files to a central SQL Server instance, or extract the data from all the .mdf files and save them to a new database?
sql-server reporting-services data-extraction edited Nov 24 '18 at 9:38
marc_s
577k12911141259
asked Nov 24 '18 at 8:46
renetonreneton
317
add a comment |
We have several engineering projects whose data is finally stored in a .mdf SQL Server database file. I now want to centralize all this engineering data and create reports about the different projects.
What would you recommend? Should I attach all the .mdf files to a central SQL Server instance, or extract the data from all the .mdf files and save them to a new database?
sql-server reporting-services data-extraction edited Nov 24 '18 at 9:38
marc_s
577k12911141259
asked Nov 24 '18 at 8:46
renetonreneton
317
add a comment |
We have several engineering projects whose data is finally stored in a .mdf SQL Server database file. I now want to centralize all this engineering data and create reports about the different projects.
What would you recommend? Should I attach all the .mdf files to a central SQL Server instance, or extract the data from all the .mdf files and save them to a new database?
sql-server reporting-services data-extraction edited Nov 24 '18 at 9:38
marc_s
577k12911141259
asked Nov 24 '18 at 8:46
renetonreneton
317
We have several engineering projects whose data is finally stored in a .mdf SQL Server database file. I now want to centralize all this engineering data and create reports about the different projects.
What would you recommend? Should I attach all the .mdf files to a central SQL Server instance, or extract the data from all the .mdf files and save them to a new database?
sql-server reporting-services data-extraction sql-server reporting-services data-extraction edited Nov 24 '18 at 9:38
marc_s
577k12911141259
asked Nov 24 '18 at 8:46
renetonreneton
317
edited Nov 24 '18 at 9:38
marc_s
577k12911141259
asked Nov 24 '18 at 8:46
renetonreneton
317
edited Nov 24 '18 at 9:38
marc_s
577k12911141259
edited Nov 24 '18 at 9:38
marc_s
577k12911141259
edited Nov 24 '18 at 9:38
marc_s
577k12911141259
577k12911141259
asked Nov 24 '18 at 8:46
renetonreneton
317
asked Nov 24 '18 at 8:46
renetonreneton
317
asked Nov 24 '18 at 8:46
renetonreneton
317
317
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Please Read This Post : (Selecting data from two different servers in SQL Server)
here
answered Nov 24 '18 at 8:50
Amirhossein_SAmirhossein_S
1
It's not exactly what I'm looking for or what I ment. The project data does not run on a server but is effectively stored in an mdf file. The question is which concept is better. Extract (ETL) or attach the several mdf files.
– reneton
Nov 24 '18 at 9:29
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Answers that are little more than a link may be deleted
– Rajesh Pandya
Nov 24 '18 at 9:29
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%2f53456588%2fattaching-several-mdf-files-to-a-sql-server-instance-or-extract-data-and-save-it%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
Please Read This Post : (Selecting data from two different servers in SQL Server)
here
answered Nov 24 '18 at 8:50
Amirhossein_SAmirhossein_S
1
It's not exactly what I'm looking for or what I ment. The project data does not run on a server but is effectively stored in an mdf file. The question is which concept is better. Extract (ETL) or attach the several mdf files.
– reneton
Nov 24 '18 at 9:29
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Answers that are little more than a link may be deleted
– Rajesh Pandya
Nov 24 '18 at 9:29
add a comment |
Please Read This Post : (Selecting data from two different servers in SQL Server)
here
answered Nov 24 '18 at 8:50
Amirhossein_SAmirhossein_S
1
It's not exactly what I'm looking for or what I ment. The project data does not run on a server but is effectively stored in an mdf file. The question is which concept is better. Extract (ETL) or attach the several mdf files.
– reneton
Nov 24 '18 at 9:29
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Answers that are little more than a link may be deleted
– Rajesh Pandya
Nov 24 '18 at 9:29
add a comment |
Please Read This Post : (Selecting data from two different servers in SQL Server)
here
answered Nov 24 '18 at 8:50
Amirhossein_SAmirhossein_S
1
Please Read This Post : (Selecting data from two different servers in SQL Server)
here
answered Nov 24 '18 at 8:50
Amirhossein_SAmirhossein_S
1
answered Nov 24 '18 at 8:50
Amirhossein_SAmirhossein_S
1
answered Nov 24 '18 at 8:50
Amirhossein_SAmirhossein_S
1
answered Nov 24 '18 at 8:50
Amirhossein_SAmirhossein_S
1
1
It's not exactly what I'm looking for or what I ment. The project data does not run on a server but is effectively stored in an mdf file. The question is which concept is better. Extract (ETL) or attach the several mdf files.
– reneton
Nov 24 '18 at 9:29
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Answers that are little more than a link may be deleted
– Rajesh Pandya
Nov 24 '18 at 9:29
add a comment |
It's not exactly what I'm looking for or what I ment. The project data does not run on a server but is effectively stored in an mdf file. The question is which concept is better. Extract (ETL) or attach the several mdf files.
– reneton
Nov 24 '18 at 9:29
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Answers that are little more than a link may be deleted
– Rajesh Pandya
Nov 24 '18 at 9:29
It's not exactly what I'm looking for or what I ment. The project data does not run on a server but is effectively stored in an mdf file. The question is which concept is better. Extract (ETL) or attach the several mdf files.
– reneton
Nov 24 '18 at 9:29
It's not exactly what I'm looking for or what I ment. The project data does not run on a server but is effectively stored in an mdf file. The question is which concept is better. Extract (ETL) or attach the several mdf files.
– reneton
Nov 24 '18 at 9:29
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Answers that are little more than a link may be deleted
– Rajesh Pandya
Nov 24 '18 at 9:29
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Answers that are little more than a link may be deleted
– Rajesh Pandya
Nov 24 '18 at 9:29
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.
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%2f53456588%2fattaching-several-mdf-files-to-a-sql-server-instance-or-extract-data-and-save-it%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
