I am hitting some limitations on SQL 2005 Express and need to migrate. This is essentially a data warehouse application and there is only one user - me. I export the data from a SQL 2005 database (multiple users) to my laptop using the Express version. I have divided Table 1 on the SQL 2005 databse into 6 tables/databases on the Express version. The other tables are manageable on the Express version. It is getting harder and harder to manage the Express version and I will have to sub-divide Table 1 even further soon.


What is the next step - cost???

What do you mean what does the next step cost?

I was really thinking of real costs for the purchase of version of SQL. I would assume that the tables, queries etc would be easily migrateed.

How much data are you using? Are you really over 4Gb (remembering to do proper maintenance to shrink the database and truncate the log)?

I export the data from a SQL 2005 database (multiple users) to my laptop using the Express version.

Please explain why you would do that. I suggest you do whatever you are doing on your server if possible. It might be hard to justify purchasing an edition of SQL Server just to run on a laptop.