Well, there is not a size issue but you may want to consider using more than one database to manage things. Your issues will be HOW you access the data if you already know you will change to SQL Server.