SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Export and Connect to SQL Server 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

MyDBA
Starting Member

2 Posts

Posted - 04/24/2012 :  18:24:35  Show Profile  Reply with Quote
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

USA
15559 Posts

Posted - 04/24/2012 :  18:31:55  Show Profile  Visit robvolk's Homepage  Reply with Quote
1. Yes
2. 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.
Go to Top of Page

MyDBA
Starting Member

2 Posts

Posted - 04/24/2012 :  18:48:39  Show Profile  Reply with Quote
quote:
Originally posted by robvolk

1. Yes
2. 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?
Go to Top of Page

robvolk
Most Valuable Yak

USA
15559 Posts

Posted - 04/24/2012 :  20:11:36  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.)
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3241 Posts

Posted - 04/25/2012 :  04:49:06  Show Profile  Reply with Quote
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...

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

robvolk
Most Valuable Yak

USA
15559 Posts

Posted - 04/25/2012 :  07:34:10  Show Profile  Visit robvolk's Homepage  Reply with Quote
Found it on Amazon:

http://www.amazon.com/SQL-Server-Developer-Edition-2012/dp/B007RFXQAM

Kinda weird it's not on Microsoft's site.
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3241 Posts

Posted - 04/25/2012 :  08:18:58  Show Profile  Reply with Quote
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.

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

robvolk
Most Valuable Yak

USA
15559 Posts

Posted - 04/25/2012 :  09:27:33  Show Profile  Visit robvolk's Homepage  Reply with Quote
Yeah, use MSDN if you have it, that's what it's there for.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000