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.
| Author |
Topic |
|
sspencer
Starting Member
1 Post |
 Posted - 2008-09-02 : 07:44:08
|
| Currently our application uses an access database with the database existing in the same directory as the application. Therefore, we can run multiple versions of our sofware at the same time.We are considering switching to using sqlexpress. As I understand, you can only have one copy of the database attached within an instance. Are there any suggestions as to how we can handle running multiple versions of our software at the same time each version having its own set of databases residing in a different location?We were hoping to use only one instance of sqlexpress.Any ideas and / or suggestions would be greatly appreciated. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-02 : 07:48:27
|
A SQL Server database is like ACCESS filename.The content of the access file is contained to one version, and the content of another access file is contained to another version.The same is for SQL Server.The content of one database is contained for one version, and the content of another database is contained to another version.However, the total database size in SQL Server Express cannot exceed 4 GB.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Multiple versions question