Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
greatsqldba
Starting Member
11 Posts |
 Posted - 2011-06-09 : 20:53:15
|
| In an environment, we have 4 databases that contain data which is used throughout an organization. Each database has data that is unique to the database. No two databases contain the same data subjects – the data in one database does not overlap the data in any other database. Each of these databases has grown organically over a 10 – 15 year history. No documentation exists on the purpose of any object within any database. However, we have Crystal Reports, Access databases, Excel spreadsheets, queries, and many other core processes that use the data in these 4 databases. You are tasked with combining all 4 databases into a single database while at the same time eliminating any objects that are no longer used. Please describe the process that you would go through to accomplish your objectives.Thanks in advance.. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-06-09 : 22:30:33
|
| Homework?CODO ERGO SUM |
 |
|
|
greatsqldba
Starting Member
11 Posts |
Posted - 2011-06-10 : 11:01:43
|
| yes again...homework.. any help is certainly appreciated.. |
|
|
|
greatsqldba
Starting Member
11 Posts |
Posted - 2011-06-10 : 21:36:58
|
| Thanks to all....Already answered the question. A little research goes along way... |
|
|
|
shivasu
Starting Member
2 Posts |
Posted - 2011-06-30 : 21:29:25
|
Please give me your answer I am looking for answer to this question too.quote:
Originally posted by greatsqldba
Thanks to all....Already answered the question. A little research goes along way...
|
|
|
|
|
|
|
Help-Combining historical db's into one db