Re: software needed to input data
From: Steve Z (szlamany_at_antarescomputing.com)
Date: 02/28/04
- Next message: Hai-Chu Hsu: "Restore databases into a new installation of SQL Server"
- Previous message: Steve Z: "Re: Can I Install SQL 2000 on XP Pro?"
- In reply to: Narayana Vyas Kondreddi: "Re: software needed to input data"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 28 Feb 2004 14:52:43 -0800
ENTERPRISE MANAGER give you a simple one table at a time
edit tool. Right click and open table - return all rows
(or just a few if you want to query the rows to look at).
You can copy/paste the data from ENTERPRISE MANAGER into
NOTEPAD and EDIT it from there. Not very safe, since tab
delimiters are easy to mess up - but for free and quick
changes, that can be done.
You can go into EXCEL - sometimes the data types change a
bit from SQL to EXCEL, but can still be done.
You could use ACCESS to create maintenance forms to modify
the data.
I'm a developer - and in my opinion, the data is yours.
Your programmer might have proprietary rights to the
schema (if a contract says so), but the data is yours.
>-----Original Message-----
>If you are database savvy, you can always get into SQL
Server, using the SQL
>cleint tools that come with SQL Server. You don't need
any additional
>software for that.
>
>But creating simple ASP forms that let you
add/edit/modify data should not
>cost you a fortune, provided you are not looking for a
very sophisticated
>'content management system'. You may want to find a
different programmer, if
>all you are after is a simple way to edit your data.
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>
>
>"Dan100" <anonymous@discussions.microsoft.com> wrote in
message
>news:1DA80330-DFC6-49F8-9CD5-0E0C27787BEF@microsoft.com...
>Thanks HTH,
>Maybe I need to explain further. I have hired a
programmer to take our HTML
>page designs (templates) and use them to create ASP pages
to display
>products from a microsoft sql database that he created
for us. We need to be
>able to get into the DB ourselves and fix the data (that
we get from a
>supplier) in the DB tables (3500 products with many
different tables,
>associations,... etc.). The programmer is telling us that
we need to buy
>several thousand $$$ dollars in software (if we want to
get into "his MS SQL
>database") in order to add or change data in it or spend
lots of $$$ to have
>him write more code for our content management system
(database interface)
>that he also wrote. Can I not get some simple version of
MS SQL or something
>so I can modify data directly without this costing me
lots of $$$? Am I
>forever at the mercy of this programmer to write me
expensive code to modify
>my own DB that I can't even see without expensive
software?
>
>Dan
>
>
>.
>
- Next message: Hai-Chu Hsu: "Restore databases into a new installation of SQL Server"
- Previous message: Steve Z: "Re: Can I Install SQL 2000 on XP Pro?"
- In reply to: Narayana Vyas Kondreddi: "Re: software needed to input data"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
