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 <[email protected]> wrote: > > > On 4/1/2015 7:33 AM, Stephen Russell wrote: > >> On Tue, Mar 31, 2015 at 4:39 PM, Jeff Johnson <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 > [email protected] > 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: [email protected] 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.
