Migration from SQL Express 2005

[Dan Roberts]

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???

 

[SQL_Hell]

What do you mean what does the next step cost?

 

[Dan Roberts]

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.

 

[SOS]

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

 

[dportas]

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.