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 |
|
MyDBA
Starting Member
2 Posts |
 Posted - 2012-04-24 : 18:24:35
|
| Have couple of questions:1. Can I connect from "SQL 2008 Developer edition" to SQL 2008 (on the remote server) to export and manage databases on SQL 2008.2. Can I also connect to SQL 2000 (on a remote server) from 2008 Developer edition.3. Is there a free download for 2008 Developer edition or do I buy it?Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-24 : 18:31:55
|
| 1. Yes2. Yes.3. Developer Edition is $49 and you can purchase it directly from Microsoft. However, make sure to never use it for production purposes, that would violate the license terms, and if you get caught will cost you a lot more than production software would. |
 |
|
|
MyDBA
Starting Member
2 Posts |
Posted - 2012-04-24 : 18:48:39
|
quote:
Originally posted by robvolk
1. Yes2. Yes.3. Developer Edition is $49 and you can purchase it directly from Microsoft. However, make sure to never use it for production purposes, that would violate the license terms, and if you get caught will cost you a lot more than production software would.
*******************************************Can I also export/ import databases from my machine to SQL Server 2008? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-24 : 20:11:36
|
| Yes. And as long as you have the proper drivers, you can import from non-SQL Server data sources (Excel, Access, text files, Oracle, MySQL, etc.) |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-04-25 : 04:49:06
|
| Rob: do you know if dev version of SQL 2012 is out yet? I haven't been able to find anywhere to buy/download it...- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-04-25 : 08:18:58
|
| Yeah, I found that too but it's a CD/DVD, I'd prefer a download of some sort. I do have a colleague that has access to MSDN though. Maybe I'll ask him to...hm...check it out for me.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-25 : 09:27:33
|
| Yeah, use MSDN if you have it, that's what it's there for. |
|
|
|
|
|
|
|
|
Export and Connect to SQL Server 2008