[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL Lite?

Posted on 2012-03-20
4
Medium Priority
?
441 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
[X]
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
  • 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 2000 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

649 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