How to Select OracleBerkeleyDB and SqlServer

I have a task in my work. I am working as an asp.net site to provide data interfaces to customers. The data volume involved is large. About records per month, and database write operations are more frequent than read operations. I used SQL Server for my previous projects, but I am worried that SQL Server may be too large in a few months, affecting performance. In addition, if the Partition Table

I have a task in my work. I am working as an asp.net site to provide data interfaces to customers. The data volume involved is large. About records per month, and database write operations are more frequent than read operations. I used SQL Server for my previous projects, but I am worried that SQL Server may be too large in a few months, affecting performance. In addition, if the Partition Table

I have a task in my work. I am working as an asp.net site to provide data interfaces to customers. The data volume involved is large. About records per month, and database write operations are more frequent than read operations.

I used SQL Server for my previous projects, but I am worried that SQL Server may be too large in a few months, affecting performance. In addition, if you want to partition a partition table, you don't know if it can automatically partition by time. I have read some tutorials on the Internet that the partition points are fixed when partitioning, in this case, regular maintenance is required for database staff. I want to avoid regular maintenance for users as much as possible.

I have some knowledge about Oracle Berkeley DB and DB4O embedded databases. The introduction of Oracle Berkeley DB on the Internet can also store a large amount of data. DB4O seems to be rarely described. Please give me some advice.HowSelect a database.

In addition, I also considered whether it can be used in combination. I used an embedded database to record data on a daily basis and regularly synchronize the data to Sqlserver. I do not know whether this method is necessary or not.