SQL Lite?

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?
LVL 1
vwchristopherDirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

micropc1Commented:
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
vwchristopherDirectorAuthor Commented:
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
micropc1Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vwchristopherDirectorAuthor Commented:
Thanks for your patience with me and this looks like what I want.  I will be testing later today and let you know!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.