Hello,

My OLAP repository is in access and has about 12 MB.

Is there any recomended limit for the capacity of an acess
repository?

I am thinking in migrating the repository to SQL Server,
butI like to have a separated enviroment between AS2000
and SQL Server.

What are the main advantages in migrating to SQL Server?

The only advantages I can see is the MetaData navigation
and the more robust Database.

Thanks in advance

Joao Campanico