我们有52个MS Access数据库,每个数据库有4个表。 我们数据库中的总数据约为500万。 现在我们计划迁移到SQL Server。 我们设计了新的数据库,它将是一个包含大约60个表的SQL Server数据库。
我的问题是 - 我们如何将52个Access数据库集成到一个SQL Server数据库中? 是否有可能,或者我们还必须在SQL Server中创建52个数据库,以便迁移我们的数据? 这52个数据库是否相互关联,在访问中具有相同的结构?
We have 52 MS Access databases and each database has 4 tables. The total data in our databases is around 5 million. Now we are planning to move to SQL Server. We have designed our new database which will be an SQL Server database with approximately 60 tables.
My question is - how will we integrate the 52 Access databases into one SQL Server database? Is it possible, or we would have to create 52 database in SQL Server too, in order to migrate our data? these 52 databases are interrelated with each other having same structure in access?
最满意答案
如果我是你(我不是,但如果我......)我会将所有数据加载到4个表中。 只需将每个Access数据库中的所有数据附加到一个表中即可。 博士,项目,合同,机构。 但是,当我附加每个数据库时,我会为每个表添加一个新字段; 国家。 然后,当您将英格兰的数据附加到表格时,还会使用“英格兰”填充该表格的“国家/地区”字段。 等等...与你所有的国家。
现在,当需要访问数据时,你可以强制某些用户只能看到英格兰的数据,而某些其他人只能看到西班牙的数据等...这样,那4个表就可以了存储您的所有数据,您仍然可以按照您喜欢的任何国家进行过滤。
If I was you (and I'm not, but if I was...) I would load all of that data into 4 tables. Just append all the data from each Access database into one table. Doctor, Project, Contract, Institution. However, as I'm appending each database, I would add a new field to each table; Country. Then, when you append the data for England to the tables, you also populate the Country field of that table with "England". Etc... with all your countries.
Now, when it comes time to access the data, you can force certain users to only be able to see the data for England, and certain other people to only see the data for Spain, etc... This way, those 4 tables can house all of your data, and you can still filter by any country you like.
更多推荐
发布评论