Re: [NF] SQL Server 2008 R2 Developer Version
On Tue, Mar 31, 2015 at 4:51 PM, Dan Covill dan.cov...@outlook.com wrote: A couple of days ago I stumbled over this: https://msdn.microsoft.com/en-us/library/hh510202.aspx It's a new form of SQL Server Express called LocalDB, and is supposed to reduce required complexity and overhead for software developers/testers. Looks good but I haven't investigated further. It's free. Dan Here's a blog post which does a pretty good job of explaining where LocalDB fits in with respect to Express and Compact editions: http://blogs.msdn.com/b/jerrynixon/archive/2012/02/26/sql-express-v-localdb-v-sql-compact-edition.aspx aka http://tinyurl.com/6mct9tn. dt -- Dave Thayer Denver, CO ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/caao+qoxcgtc3lytjddpqkpvo7nzpxx4uum785fxmvmpe8uw...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
On Tue, Mar 31, 2015 at 4:39 PM, Jeff Johnson j...@san-dc.com wrote: Database is large. Thanks and you better not go anywhere! On 3/31/2015 2:35 PM, Ted Roche wrote: Or the SQL Server express 2008 R2 edition, which is what you asked for initially! http://www.microsoft.com/en-us/download/details.aspx?id=30438 Surprised to see these still available. On Tue, Mar 31, 2015 at 5:33 PM, Ted Roche tedro...@gmail.com wrote: I should be here less often :) If the database isn't huge, you could probably get by with SQL Server Express: http://www.microsoft.com/en-us/download/details.aspx?id=29062 On Tue, Mar 31, 2015 at 5:32 PM, Jeff Johnson j...@san-dc.com wrote: Thanks Ted. Stephen must be absent today. We miss you when you aren't here. ;^) On 3/31/2015 2:28 PM, Ted Roche wrote: I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was discussion here on a FREE developer edition, but now I can't locate that thread. $49 seems like a reasonable deal. I would expect a later db to read a dump from an earlier one, but don't expect you can dump this into an earlier edition. I have done it, by generating SQL Scripts, targeting early versions, but there's no guarantee that will work. - Whole lot of possible incorrect statements going on in this thread. Are you making schema changes in the db on your system and then updating the client? Do they have SS2008-R2 in which version? If you are not making a restore of their system after you tweak it on your own you can use 2008, 12, 14 to do anything you want on your end. The newer may have a tough time restoring backwards DEPENDING on VERSION, Enterprise-Data Center-etc. From Amazon you can get Developer for 50-80 USD and that is a steal compared to buying Enterprise for possibly as low as 10,000. The developer version does everything Enterprise does but not for end users. We run our prod server on Enterprise and our test server on Developer. I will not go into how much enterprise costs because I don't know what we finally agreed to with M$. BABS has 256 gig of ram and 64 cores. Now WHAT DO YOU HAVE TO ACCOMPLISH? Can we get a list of major tasks that need to be done? If so you can get guidance in best processes to follow. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYJMqD3NuTVoOAip=VHn0AkxATo0bg=x_3kmpdrgybo...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] SQL Server 2008 R2 Developer Version
From the Words Have Meaning Department, there is no more Enterprise Manager, Jeff. :-) There is only SSMS. The learning curve shouldn't be too bad especially considering what you want to do. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, April 01, 2015 11:47 AM To: profoxt...@leafe.com Subject: Re: [NF] SQL Server 2008 R2 Developer Version Not sure where on the page for download but it will have a list of other files to download and one of them will be Manager, another will be Reporting services, Analytically Services, etc. Or you can download everything for free and have that 10 gig limit to a DB. On Wed, Apr 1, 2015 at 10:24 AM, Jeff Johnson j...@san-dc.com wrote: Welcome back Stephen! I have a backup of two databases from SQL Server 2008 R2. Based on where it came from I would assume enterprise addition. All I want to do is restore them to SQL Server so I can export the data so I can put it into VFP tables in my application. No changes, read only. I am only going to do this once, so I don't want to have to spend a lot of money. Also, I would like the Enterprise Manager tool because I am somewhat familiar with that and can help me with the export. Thanks, -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/blupr10mb04519068fcc4ff75fbd88717d2...@blupr10mb0451.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
You can download the free Express edition of 2012 or 2014 and restore the backup(s) easily. Not sure where on the page for download but it will have a list of other files to download and one of them will be Manager, another will be Reporting services, Analytically Services, etc. Or you can download everything for free and have that 10 gig limit to a DB. Because you are SA on your box you should have no trouble with ability to gain access into this db. Once you have the DB restored you can rt click on the db name and Export Data is towards the bottom. I have no idea if the VFP data driver will work here so I would use excel output or access to catch any table you want to throw at it. Works real fast and all you have to do is define the file name or table name depending on the container you choose. Hope this helps. On Wed, Apr 1, 2015 at 10:24 AM, Jeff Johnson j...@san-dc.com wrote: On 4/1/2015 7:33 AM, Stephen Russell wrote: On Tue, Mar 31, 2015 at 4:39 PM, Jeff Johnson j...@san-dc.com wrote: Database is large. Thanks and you better not go anywhere! On 3/31/2015 2:35 PM, Ted Roche wrote: Or the SQL Server express 2008 R2 edition, which is what you asked for initially! http://www.microsoft.com/en-us/download/details.aspx?id=30438 Surprised to see these still available. On Tue, Mar 31, 2015 at 5:33 PM, Ted Roche tedro...@gmail.com wrote: I should be here less often :) If the database isn't huge, you could probably get by with SQL Server Express: http://www.microsoft.com/en-us/download/details.aspx?id=29062 On Tue, Mar 31, 2015 at 5:32 PM, Jeff Johnson j...@san-dc.com wrote: Thanks Ted. Stephen must be absent today. We miss you when you aren't here. ;^) On 3/31/2015 2:28 PM, Ted Roche wrote: I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was discussion here on a FREE developer edition, but now I can't locate that thread. $49 seems like a reasonable deal. I would expect a later db to read a dump from an earlier one, but don't expect you can dump this into an earlier edition. I have done it, by generating SQL Scripts, targeting early versions, but there's no guarantee that will work. - Whole lot of possible incorrect statements going on in this thread. Are you making schema changes in the db on your system and then updating the client? Do they have SS2008-R2 in which version? If you are not making a restore of their system after you tweak it on your own you can use 2008, 12, 14 to do anything you want on your end. The newer may have a tough time restoring backwards DEPENDING on VERSION, Enterprise-Data Center-etc. From Amazon you can get Developer for 50-80 USD and that is a steal compared to buying Enterprise for possibly as low as 10,000. The developer version does everything Enterprise does but not for end users. We run our prod server on Enterprise and our test server on Developer. I will not go into how much enterprise costs because I don't know what we finally agreed to with M$. BABS has 256 gig of ram and 64 cores. Now WHAT DO YOU HAVE TO ACCOMPLISH? Can we get a list of major tasks that need to be done? If so you can get guidance in best processes to follow. Welcome back Stephen! I have a backup of two databases from SQL Server 2008 R2. Based on where it came from I would assume enterprise addition. All I want to do is restore them to SQL Server so I can export the data so I can put it into VFP tables in my application. No changes, read only. I am only going to do this once, so I don't want to have to spend a lot of money. Also, I would like the Enterprise Manager tool because I am somewhat familiar with that and can help me with the export. Thanks, -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmykqgghpzdpovgqijfhxueyj9ra00_wimq+r-8u8le8...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
On 4/1/2015 7:33 AM, Stephen Russell wrote: On Tue, Mar 31, 2015 at 4:39 PM, Jeff Johnson j...@san-dc.com wrote: Database is large. Thanks and you better not go anywhere! On 3/31/2015 2:35 PM, Ted Roche wrote: Or the SQL Server express 2008 R2 edition, which is what you asked for initially! http://www.microsoft.com/en-us/download/details.aspx?id=30438 Surprised to see these still available. On Tue, Mar 31, 2015 at 5:33 PM, Ted Roche tedro...@gmail.com wrote: I should be here less often :) If the database isn't huge, you could probably get by with SQL Server Express: http://www.microsoft.com/en-us/download/details.aspx?id=29062 On Tue, Mar 31, 2015 at 5:32 PM, Jeff Johnson j...@san-dc.com wrote: Thanks Ted. Stephen must be absent today. We miss you when you aren't here. ;^) On 3/31/2015 2:28 PM, Ted Roche wrote: I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was discussion here on a FREE developer edition, but now I can't locate that thread. $49 seems like a reasonable deal. I would expect a later db to read a dump from an earlier one, but don't expect you can dump this into an earlier edition. I have done it, by generating SQL Scripts, targeting early versions, but there's no guarantee that will work. - Whole lot of possible incorrect statements going on in this thread. Are you making schema changes in the db on your system and then updating the client? Do they have SS2008-R2 in which version? If you are not making a restore of their system after you tweak it on your own you can use 2008, 12, 14 to do anything you want on your end. The newer may have a tough time restoring backwards DEPENDING on VERSION, Enterprise-Data Center-etc. From Amazon you can get Developer for 50-80 USD and that is a steal compared to buying Enterprise for possibly as low as 10,000. The developer version does everything Enterprise does but not for end users. We run our prod server on Enterprise and our test server on Developer. I will not go into how much enterprise costs because I don't know what we finally agreed to with M$. BABS has 256 gig of ram and 64 cores. Now WHAT DO YOU HAVE TO ACCOMPLISH? Can we get a list of major tasks that need to be done? If so you can get guidance in best processes to follow. Welcome back Stephen! I have a backup of two databases from SQL Server 2008 R2. Based on where it came from I would assume enterprise addition. All I want to do is restore them to SQL Server so I can export the data so I can put it into VFP tables in my application. No changes, read only. I am only going to do this once, so I don't want to have to spend a lot of money. Also, I would like the Enterprise Manager tool because I am somewhat familiar with that and can help me with the export. Thanks, -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/551c0dc8.4010...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] SQL Server 2008 R2 Developer Version
When I was active, this was how I stayed up on software https://mspartner.microsoft.com/en/hk/pages/membership/action-pack-subscribe .aspx -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, March 31, 2015 3:49 PM To: profox@leafe.com Subject: [NF] SQL Server 2008 R2 Developer Version I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way to get SQL Server 2008 R2 on one computer for development only? If so, where? TIA -- Jeff Jeff Johnson j...@dcsoftware.com (623) 582-0323 Please reply to j...@san-dc.com! Visit our forum at www.san-dc.com/forum Register and join in the discussion [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01a301d06bf4$aa0bd9c0$fe238d40$@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
Can't afford it for this project. All I need to do is restore a backup and export data from the database. Thanks, On 3/31/2015 1:52 PM, Virgil Bierschwale wrote: When I was active, this was how I stayed up on software https://mspartner.microsoft.com/en/hk/pages/membership/action-pack-subscribe .aspx -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, March 31, 2015 3:49 PM To: profox@leafe.com Subject: [NF] SQL Server 2008 R2 Developer Version I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way to get SQL Server 2008 R2 on one computer for development only? If so, where? TIA -- Jeff Jeff Johnson j...@dcsoftware.com (623) 582-0323 Please reply to j...@san-dc.com! Visit our forum at www.san-dc.com/forum Register and join in the discussion [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/551b09df.1000...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
That link takes me to Amazon and SQL Server 2014 for $49.00. Can I restore a backup of 2008 R2 into this? The $49 is okay by me. On 3/31/2015 2:06 PM, Ted Roche wrote: Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff Johnson j...@dcsoftware.com wrote: I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way to get SQL Server 2008 R2 on one computer for development only? If so, where? -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/551b0ebc.2010...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
Thanks Ted. Stephen must be absent today. We miss you when you aren't here. ;^) On 3/31/2015 2:28 PM, Ted Roche wrote: I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was discussion here on a FREE developer edition, but now I can't locate that thread. $49 seems like a reasonable deal. I would expect a later db to read a dump from an earlier one, but don't expect you can dump this into an earlier edition. I have done it, by generating SQL Scripts, targeting early versions, but there's no guarantee that will work. On Tue, Mar 31, 2015 at 5:16 PM, Jeff Johnson j...@san-dc.com wrote: That link takes me to Amazon and SQL Server 2014 for $49.00. Can I restore a backup of 2008 R2 into this? The $49 is okay by me. On 3/31/2015 2:06 PM, Ted Roche wrote: Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff Johnson j...@dcsoftware.com wrote: I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way to get SQL Server 2008 R2 on one computer for development only? If so, where? -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/551b1271.5020...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
Or the SQL Server express 2008 R2 edition, which is what you asked for initially! http://www.microsoft.com/en-us/download/details.aspx?id=30438 Surprised to see these still available. On Tue, Mar 31, 2015 at 5:33 PM, Ted Roche tedro...@gmail.com wrote: I should be here less often :) If the database isn't huge, you could probably get by with SQL Server Express: http://www.microsoft.com/en-us/download/details.aspx?id=29062 On Tue, Mar 31, 2015 at 5:32 PM, Jeff Johnson j...@san-dc.com wrote: Thanks Ted. Stephen must be absent today. We miss you when you aren't here. ;^) On 3/31/2015 2:28 PM, Ted Roche wrote: I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was discussion here on a FREE developer edition, but now I can't locate that thread. $49 seems like a reasonable deal. I would expect a later db to read a dump from an earlier one, but don't expect you can dump this into an earlier edition. I have done it, by generating SQL Scripts, targeting early versions, but there's no guarantee that will work. On Tue, Mar 31, 2015 at 5:16 PM, Jeff Johnson j...@san-dc.com wrote: That link takes me to Amazon and SQL Server 2014 for $49.00. Can I restore a backup of 2008 R2 into this? The $49 is okay by me. On 3/31/2015 2:06 PM, Ted Roche wrote: Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff Johnson j...@dcsoftware.com wrote: I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way to get SQL Server 2008 R2 on one computer for development only? If so, where? -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4tkdkv_ehm3ozq_vswfvnbrdaudtyvejhxwjzj8mmw...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
Database is large. Thanks and you better not go anywhere! On 3/31/2015 2:35 PM, Ted Roche wrote: Or the SQL Server express 2008 R2 edition, which is what you asked for initially! http://www.microsoft.com/en-us/download/details.aspx?id=30438 Surprised to see these still available. On Tue, Mar 31, 2015 at 5:33 PM, Ted Roche tedro...@gmail.com wrote: I should be here less often :) If the database isn't huge, you could probably get by with SQL Server Express: http://www.microsoft.com/en-us/download/details.aspx?id=29062 On Tue, Mar 31, 2015 at 5:32 PM, Jeff Johnson j...@san-dc.com wrote: Thanks Ted. Stephen must be absent today. We miss you when you aren't here. ;^) On 3/31/2015 2:28 PM, Ted Roche wrote: I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was discussion here on a FREE developer edition, but now I can't locate that thread. $49 seems like a reasonable deal. I would expect a later db to read a dump from an earlier one, but don't expect you can dump this into an earlier edition. I have done it, by generating SQL Scripts, targeting early versions, but there's no guarantee that will work. On Tue, Mar 31, 2015 at 5:16 PM, Jeff Johnson j...@san-dc.com wrote: That link takes me to Amazon and SQL Server 2014 for $49.00. Can I restore a backup of 2008 R2 into this? The $49 is okay by me. On 3/31/2015 2:06 PM, Ted Roche wrote: Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff Johnson j...@dcsoftware.com wrote: I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way to get SQL Server 2008 R2 on one computer for development only? If so, where? -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/551b1424.7050...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
I should be here less often :) If the database isn't huge, you could probably get by with SQL Server Express: http://www.microsoft.com/en-us/download/details.aspx?id=29062 On Tue, Mar 31, 2015 at 5:32 PM, Jeff Johnson j...@san-dc.com wrote: Thanks Ted. Stephen must be absent today. We miss you when you aren't here. ;^) On 3/31/2015 2:28 PM, Ted Roche wrote: I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was discussion here on a FREE developer edition, but now I can't locate that thread. $49 seems like a reasonable deal. I would expect a later db to read a dump from an earlier one, but don't expect you can dump this into an earlier edition. I have done it, by generating SQL Scripts, targeting early versions, but there's no guarantee that will work. On Tue, Mar 31, 2015 at 5:16 PM, Jeff Johnson j...@san-dc.com wrote: That link takes me to Amazon and SQL Server 2014 for $49.00. Can I restore a backup of 2008 R2 into this? The $49 is okay by me. On 3/31/2015 2:06 PM, Ted Roche wrote: Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff Johnson j...@dcsoftware.com wrote: I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way to get SQL Server 2008 R2 on one computer for development only? If so, where? -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4uGHp-x9pwHvH1xb15RNCNPhSsgN_5NbgPb=pmw21d...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
I need the enterprise manager (or whatever it is called now) software because I don't have time to learn to manipulate express. Thanks, On 3/31/2015 2:53 PM, Richard Kaye wrote: Large is a relative term, Jeff. Does it exceed the capacities of the current Express version? If not, you should be able to just get that. And one change over time is they also make SSMS available to Express users. It used to be SSMS was not available so you got the engine but not the dev tools. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, March 31, 2015 5:40 PM To: profoxt...@leafe.com Subject: Re: [NF] SQL Server 2008 R2 Developer Version Database is large. Thanks and you better not go anywhere! [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/551b18ab.4030...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] SQL Server 2008 R2 Developer Version
SSMS = SQL Server Management Studio. This is actually the 2008 R2 version I just found. http://www.microsoft.com/en-us/download/details.aspx?id=22985 And then there's the 2014 download but it's not 100% clear to me if this is time limited in any way since the page refers to eval. https://msdn.microsoft.com/en-us/evalcenter/dn434042.aspx -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, March 31, 2015 5:59 PM To: profoxt...@leafe.com Subject: Re: [NF] SQL Server 2008 R2 Developer Version I need the enterprise manager (or whatever it is called now) software because I don't have time to learn to manipulate express. Thanks, ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/blupr10mb045194b74ea40df357193089d2...@blupr10mb0451.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was discussion here on a FREE developer edition, but now I can't locate that thread. $49 seems like a reasonable deal. I would expect a later db to read a dump from an earlier one, but don't expect you can dump this into an earlier edition. I have done it, by generating SQL Scripts, targeting early versions, but there's no guarantee that will work. On Tue, Mar 31, 2015 at 5:16 PM, Jeff Johnson j...@san-dc.com wrote: That link takes me to Amazon and SQL Server 2014 for $49.00. Can I restore a backup of 2008 R2 into this? The $49 is okay by me. On 3/31/2015 2:06 PM, Ted Roche wrote: Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff Johnson j...@dcsoftware.com wrote: I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way to get SQL Server 2008 R2 on one computer for development only? If so, where? -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4tZZVwOeZyicabYNw4AK2My2Df4nU_pBW=yculthex...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] SQL Server 2008 R2 Developer Version
Large is a relative term, Jeff. Does it exceed the capacities of the current Express version? If not, you should be able to just get that. And one change over time is they also make SSMS available to Express users. It used to be SSMS was not available so you got the engine but not the dev tools. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, March 31, 2015 5:40 PM To: profoxt...@leafe.com Subject: Re: [NF] SQL Server 2008 R2 Developer Version Database is large. Thanks and you better not go anywhere! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/blupr10mb0451fd0315985e3dd9951540d2...@blupr10mb0451.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] SQL Server 2008 R2 Developer Version
Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff Johnson j...@dcsoftware.com wrote: I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way to get SQL Server 2008 R2 on one computer for development only? If so, where? -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4vihnU1BYdKJPuM3YN-PcZNEft=km62fpk9pfv+tao...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] SQL Server 2008 R2 Developer Version
A couple of days ago I stumbled over this: https://msdn.microsoft.com/en-us/library/hh510202.aspx It's a new form of SQL Server Express called LocalDB, and is supposed to reduce required complexity and overhead for software developers/testers. Looks good but I haven't investigated further. It's free. Dan From: rk...@invaluable.com To: profoxt...@leafe.com Subject: RE: [NF] SQL Server 2008 R2 Developer Version Date: Tue, 31 Mar 2015 22:08:04 + SSMS = SQL Server Management Studio. This is actually the 2008 R2 version I just found. http://www.microsoft.com/en-us/download/details.aspx?id=22985 And then there's the 2014 download but it's not 100% clear to me if this is time limited in any way since the page refers to eval. https://msdn.microsoft.com/en-us/evalcenter/dn434042.aspx -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, March 31, 2015 5:59 PM To: profoxt...@leafe.com Subject: Re: [NF] SQL Server 2008 R2 Developer Version I need the enterprise manager (or whatever it is called now) software because I don't have time to learn to manipulate express. Thanks, [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bay169-w78b1fc220cacbbc544b50c8a...@phx.gbl ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
