| Author |
 Topic  |
|
Astralis
Senior Member
USA
1218 Posts |
 Posted - 26 January 2006 : 00:23:05
|
| I am installing a new system and have to setup SQL Server and Enterprise Manager on my machine. I did this last time by downloading something on Microsoft and it didn't require me to pay. Is it the desktop engine? |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 26 January 2006 : 06:13:25
|
I keep thinking it's MSDE. Whatever it was installed MSSQL Server onto my PC and I was able to manage tables and hold data using EM.
Here are two links where I talked about it and downloaded it:
Link One
Link Two
Some Questions
Will the SQL Server 2005 Express edition provide me with all the space I need to hold backups of tables?
Does it come with EM?
My SQL Server on my hosted account is MSSQL Server 2000. Will this upgrade still work?
If I did use MSDE before, which I think I did, is that still available to download? |
Edited by - Astralis on 26 January 2006 06:26:43 |
 |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 26 January 2006 : 06:14:04
|
| There is a .net version of EM that is free. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 January 2006 : 06:24:24
|
| With SQL Server 2000 you could just install the client tools (which included EM). Don't know the exact situation with SQL Server 2005, but there's still a trial. Anyway, the developer edition of SQL 2000 had a cost of $50. Likely that won't have changed with SQL 2005 and the price makes it probably worthy. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 26 January 2006 : 06:28:28
|
First, thanks HuwR and ruirib for helping.
I asked some questions in my edited post (I was editing it as you both replied). |
|
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 26 January 2006 : 06:34:56
|
HuwR, what's this .net version of EM?
The questions above might help with the following question: Does EM allow me to save and view the files locally on my own machine? Somehow, the version that I had last time installed a MSSQL Server on my PC. Is this part of EM? Or do I have to find is separately?
I am quite certain this is the link I used to download the applications:
http://www.microsoft.com/sql/msde/
It now goes to the SQL Server 2005 Express, though. So, I think it was the Desktop Engine. |
Edited by - Astralis on 26 January 2006 06:35:44 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 26 January 2006 : 07:15:22
|
These guys are giving away the "Lite" versions of their software for free. For most of what you need, it should be ok. (and the 'free' helps a lot too  )
http://www.sqlmanager.net/ |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 January 2006 : 08:09:27
|
There is no MSDE any longer. 2005 version is named SQL Server 2005 Express Edition. I don't think it comes with EM, no. An Access Data Project can be used to control a SQL Server DB, so you may try it.
Maybe you can give a go at the SQL Server trial edition. It's good for 180 days. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 26 January 2006 : 08:34:05
|
quote:
Originally posted by Astralis
HuwR, what's this .net version of EM?
it is a web manager for MSSQL http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
quote:
The questions above might help with the following question: Does EM allow me to save and view the files locally on my own machine? Somehow, the version that I had last time installed a MSSQL Server on my PC. Is this part of EM? Or do I have to find is separately?
EM is or was part of MSSQL, MSDE has now been superceded by the 2005 Express version which I don't think includes EM.
|
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 26 January 2006 : 16:06:56
|
| Has anyone tried it? Are there limitations to it? |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 26 January 2006 : 18:37:18
|
I found SQL Server 2000 software in my files and I loaded it and now I have it installed with Enterprise Manager. I guess I did have this in the past. I don't know how, though.
Now that SQL Server 2005 is out, what is everyone using to manage it? SQL Server Management Studio?
Can I use that with SQL Server 2000? Is it scalable?
quote:
DTS (Copy Wizard) seems to be missing
Wow. It looks like HuwR's suggestion of using the web-based .NET EM might be the best choice. |
Edited by - Astralis on 26 January 2006 18:50:07 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
