Solved

SQL Lite?

Posted on 2012-03-20
4
419 Views
Last Modified: 2012-04-06
I am an IT person, not a db person.  We have an external user who wants the following:  "the ability to modify some code I've already written, and to make sure it works on a database from the client. So I think a minimalist installation of SQL (without all the Management Studio/Enterprise Manager) add-ons would work, so long as there's a query editor and a way to point it at a .csv file. "

I don't know what questions to ask him and wonder if EMS SQL Manager Lite for SQL Server 2008 will be sufficient and does it work with Windows XP sp2?
0
Comment
Question by:vwchristopher
  • 2
  • 2
4 Comments
 
LVL 7

Expert Comment

by:micropc1
Comment Utility
He probably just needs SQL 2008 Express and Management Studio Express - and yes, that works with Windows XP.

http://www.microsoft.com/sqlserver/en/us/editions/express.aspx
0
 
LVL 1

Author Comment

by:vwchristopher
Comment Utility
The link you attached is for 2012, which doesn't work with windows XP, which is why I asked about the other link - When I queried the user about what he's doing here's what he wrote.  What do I need?

The end user wants to edit existing code.  The code was originally written in Enterprise Managers's SQL Query Analyzer. It isn't especially fancy, so I'm hopeful that it would be transferable to another implementation of SQL (there are apparently some difference between T-SQL (microsoft's version) and others, but I doubt my code invokes any of them). The database is just one, flat, quite large .csv file that the client sends to us every quarter. For the program, I'd just need something to upload the csv to, plus a facility for making edits to the code, and then executing it against the .csv/database
0
 
LVL 7

Accepted Solution

by:
micropc1 earned 500 total points
Comment Utility
The URL above actually links to older versions too if you click 'Previous Editions' at the top...

Here's a direct link to SQL Express 2008.. http://www.microsoft.com/download/en/details.aspx?id=1695

And 2008 Management studio express.. http://www.microsoft.com/download/en/details.aspx?id=7593

From their website...
Supported operating systems: Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Vista, Windows Vista Service Pack 1, Windows XP Service Pack 2, Windows XP Service Pack 3

To import a CSV file into a Microsoft SQL database you'll need to use the bcp utility or a BULK IMPORT SQL statement.
0
 
LVL 1

Author Comment

by:vwchristopher
Comment Utility
Thanks for your patience with me and this looks like what I want.  I will be testing later today and let you know!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now