Alright, I understand the vast improvements in terms of scalability and speed of ms sql. My question is, if I have for example 8 different access databases, if I were to switch over to ms sql, would I combine all these into one SQL database, or would it be similar to access where i have 8 .mdb files.
The two main databases affected would be a forum db and a professor evaluation db (which will be holding 10s of thousands of entries each of which contains 3 memo fields and a fair amount of data).
SQL Server is not like Access in that you don't directly manipulate the database files (well, usually, anyway).
If the SQL Server is yours you can choose to create separate databases for each of your migrated mdb's. If your server is remotely hosted, you may only have one database available so you'd need to put all your tables in the one db.
Topic Locked
Posted - 30 October 2003 : 20:30:00
