使用C#拆分Access数据库? [英] Split Access database with c#?

问题描述

我需要分割Access数据库(大小接近2Gb)，
c#有可能吗?
如果是真的，怎么办?

Hi,
I need split my Access db(size is near 2Gb),
is this possible with c#?
if it is true,How?

推荐答案

如果在压缩数据库后它仍然太大...

如果您希望Access数据库可以作为一组多个文件工作，则不会.您的数据库不能跨越多个文件.您已经完全超出了Access的容量，需要升级到某些版本的SQL Server.

If after you compact the database and it''s still too big...

If you''re expecting an Access database to work as a set of multiple files, it won''t. You cannot have a database span multiple files. You have simply outgrown the capacity of Access and need to upsize to some edition of SQL Server.

这里是一个不错的解决方案:将数据移至 ^ ]-最多可处理10 GB，当出现问题时，您可以升级服务器.

这里是一些更多信息:
迁移到SQL Server 2008 [

Here is a nice solution: Move the data to SQL Server Express[^] - Handles up to 10 GB, and when that becomes a problem you can upgrade the server.

Here is some more information:
Migrating to SQL Server 2008[^]

Regards
Espen Harlinn

确定要拆分吗?您是否尝试过首先压缩它?

但是，是的，这是有可能的……但是结构上的彻底改变会改变一切，并需要对含义和新结构进行大量思考.

Are you sure you need to split it? Have you tried compacting it first?

But, yes, it''s possible...but a complete change in structure like that changes everything and takes a lot of thinking through the implications and the new structure.

这篇关于使用C#拆分Access数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！