Solved

SQL Lite?

Posted on 2012-03-20
4
421 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

910 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

21 Experts available now in Live!

Get 1:1 Help Now