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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2011-03-30 : 13:30:33
|
| I have a program that is now on a shared hosting server in sql 7.I have sql 7 enterprise manager which I can import and export and use all it's features I have an option to move the database to sql 2005 but then I will just have the basic sql express management studio what would you do? Is there a big enough advantage of sql 2005 to switch though I will lose the option of dts (which i don't think I can do from sql express and i'm not buying a full version now) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-30 : 13:47:23
|
| You can also buy SQL Server Developer Edition for $49 if you want the full tools. You just can't install the database engine in a production environment under that license. You'll also get the SSIS tools through Business Intelligence Studio. |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2011-03-31 : 01:39:42
|
| You can also buy SQL Server Developer Edition for $49 Is this for client that I can use for all?as it's on a hosted server so I have limits as well - can you do bcp from express on a shared server. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-31 : 08:02:07
|
| bcp can work with any SQL Server instance, as long as you have network access and the proper credentials. A shared machine will be accessed via IP address. The same applies for Management Studio and Express Tools. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2011-03-31 : 08:27:24
|
| so if i buy this $49 version I could then use it and be able to use the import features? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-31 : 09:33:03
|
| Yes. As I said earlier, the only restriction is using DB, Analysis Services, and other engine components in production. |
|
|
|
|
|
|
sql 2005 vs sql 7