Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Migration from 2005 Express

Author  Topic  bricer Starting Member 1 Post Posted - 2009-07-31 : 11:06:49 Two parts to this question - What version and what hardware I have a rather large database of medical claims that I audit. I download data from a traditional SQL database into series of databases on my laptop using SQL Express. I am forced to divide the 'claims' database into 7 databases on my laptop because of database size limitations in SQL Express. I end up with a total of 14 databases with all of the other data on consumers, providers etc. It is a cumbersome process and the databases are oddly fragile. I am forced to write many queries with 'unions' and "Views" are problematic across databases. I am the only user of the laptop version and that is unlikely to change. What would be the migration from 2005 Express version? If I upgrade the laptop, there are other considerations, what are some of the memory or other hardware considerations.