SQL Server Database design

Ashok Govindan 1 Reputation point
2020-09-25T19:06:16.483+00:00

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.
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
{count} votes