SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,337 questions
SQL Server Database design
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 13%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ashok Govindan
1
Reputation point
Hello,
What is the best SQL Server design approach that we could use for the below scenario:
- MS Access Databases are used to store, retrieve and process the data.
- Around 50 databases are in production utilized by 50 different UDAs.
- 10~15 input sources for these 50 databases and 10% of fields may likely be the same.
- Need a SQL database with tables that can accommodate all the above tables and any future projects that may occur.
{count} votes
-
Erland Sommarskog 115.7K Reputation points MVP2020-09-25T21:29:16.917+00:00 So these 50 Access databases all have the same schema? And then you want to consolidate them into a single database?
I'm afraid that this is a question that cannot easily be answered in a forum. To give a good answer I would need quite intimate knowledge of the source databases and the requirements. But maybe we can offer some high-level ideas, if we get some more input.
Sign in to comment
Sign in to answer