Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL Lite?

Posted on 2012-03-20
4
430 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
ID: 37745209
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
ID: 37747917
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
ID: 37748033
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
ID: 37749113
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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