Sql Server 2008 Instaled but Pronest Need Again
3 Answers 3
There is no reason to. Install just the one 2012 edition. Then use "astern compatibility way" one database can be run using the 2012 engine while the other database can be run using the 2008 engine (that comes with the 2012 install). When you lot do select @@version you volition get one version from one database and another from the other all on the same single server. (and don't utilise the express version!!!! it is useless)
answered Aug 27, 2022 at 1:01
M T HeadM T Caput
929 vii silverish badges 12 statuary badges
v
If I install SQL Server 2012 Express (on Windows 7) where I already accept SQL Server 2008 Express, will they coexist? And will I be able to use SSMS 2022 connect to one or the other?
Aye they will. I accept iv instances: 2005, 2008R2, 2012 and 2022 installed on the same pc. And yeah, you lot'll be able to connect to all of them using SSMS 2016
Also, since SQL Server 2008 Limited is installed in c:\Plan Files\Microsoft SQL Server\MSSQL10.MSSQLServer\MSSQL\, where would the SQL Server 2012 Limited become?
C:\Program Files\Microsoft SQL Server\MSSQL11.\MSSQL\
answered Aug 28, 2022 at 8:37
sepupicsepupic
eight,184 i aureate badge 8 silver badges 17 bronze badges
five
-
Cheers for your input. Unfortunately, subsequently I installed SQL Server 2022 Limited, the SSMS 2022 stopped working at all. When I click on the shortcut for SSMS 2022 I only hear a click but nothing opens and no error message.
Aug 29, 2022 at eleven:24
-
Cheque the link the shortcut is pointing to, it can be changed. Endeavour to locate SSMS2016 and launch information technology without using shortcut
Aug 29, 2022 at xi:26
-
The aforementioned - negative - result when I try to launch SSMS2016 from the Programs bill of fare. I may take to uninstall it and install again.
Aug 29, 2022 at xi:46
-
Programs menu besides contains just shortcuts, merely did you try to locate the .exe file and launch it?
Aug 29, 2022 at 11:51
-
I did. I practice find this file (ssms.exe) in the SQL Server Management Studio binder but the same results when I try to launch it. The odd thing is that the SSMS is in the Program Files (x86). I thought it should be in the Program Files. Merely in any event, it does not work.
Aug 29, 2022 at 12:00
answered Aug 26, 2022 at 23:20
HoraciuxHoraciux
four,758 ii gold badges 21 silvery badges xl bronze badges
ane
-
From what I read online the SQL Server 2022 will not install on Windows vii. This is why I am because installing SQL Server 2012 Express. Thank you.
Aug 26, 2022 at 23:32
Not the answer y'all're looking for? Browse other questions tagged sql sql-server sql-server-express or ask your own question.
rodrigueztorrisheacer39.blogspot.com
Source: https://stackoverflow.com/questions/45900350/can-sql-server-2012-express-coexist-with-sql-server-2008-express
M T Head. Thanks. Helpful suggestion. Although at this point I can't beget the standard edition. So Express will do.
Aug 27, 2022 at ane:39
Alert: once you've "upgraded" a
.mdfdatabase file to the newer version (SQL Server 2012 Limited), you lot tin NEVER go back again - you cannot backup & restore, or detach & adhere a 2012.mdfback to a SQL Server 2008 instance anymore. The "astern compatibility mode" does not help here, either....Aug 27, 2022 at 7:38
@marc_s Yes, I realize that the database cannot be downgraded. I likewise found, since my last mail service, that SQL Server 2022 Limited also works on Windows 7. So this is what I volition download and install. Cheers.
Aug 27, 2022 at xiii:05
I don't meet where you tin't utilize backward compatibility mode. When you take your 2008 database and put it on 2012. It comes over as 2008 astern compatibility mode. Yep you can't put it dorsum on a 2008 server. But why would you want to. If you are running 2012 on the box anyway why run ii dissimilar versions?
Aug 27, 2022 at 16:sixteen
Likewise if it is a matter of costs. Express is horribly restricted on its functionality. If you don't absolutely have to employ a MS Sql database I would suggest going to Postgres which is free and does not have the restrictions they put on you with the express version.
Aug 27, 2022 at 16:41