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

DB with 700 tables and no documentation or source code help

Posted on 2007-11-29
13
156 Views
Last Modified: 2010-04-23
Hi, I am new at my company, and want to figure out which table has what. I have no code or docs from the previous programmers work and must figure it out myself.

Using "Add New Data Source" I can connect to the MS SQL 2000 server and see the ~700 tables. I can add a table, drag it to the form, compile and see the cells in a datagridview. I have gotten a user to save some data, and now I want to look for it, and know where it is.

How can I automate going through the tables and looking for the data that the user saved for me? Here is the code I get in my form when I do the above, and get one of the tables:

    Private Sub BsoRelMasterBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BsoRelMasterBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.BsoRelMasterBindingSource.EndEdit()
        Me.BsoRelMasterTableAdapter.Update(Me.CompanyADataSet.BsoRelMaster)
    End Sub

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'CompanyADataSet.BsoRelMaster' table. You can move, or remove it, as needed.
        Me.BsoRelMasterTableAdapter.Fill(Me.CompanyADataSet.BsoRelMaster)
    End Sub
0
Comment
Question by:Pizpot
  • 7
  • 6
13 Comments
 
LVL 18

Accepted Solution

by:
jcoehoorn earned 500 total points
ID: 20375442
My condolences.  If you don't already have it, you'll want to download SQL Server Management Studio from Microsoft's web site.  Use that to connect to the database and browse the tables a little easier.  
0
 

Author Comment

by:Pizpot
ID: 20375602
I am going there now, and that might satisfy me, but I know I'll need code for such operations soon enough.
0
 

Author Comment

by:Pizpot
ID: 20375722
It looks like SQL Server Management Studio is for SQL Server 2005, but we are on 2000. Is there an edition for that, or anyone know the code I need? Would the solution be to connect to the tables one at a time and then loop through the rows and cols to look for a string? That is what I think I want here. :-) Having that code will allow me to do quite a lot of things...
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 18

Expert Comment

by:jcoehoorn
ID: 20375788
SQL Server management studio will connect to 2000 just fine.  You need to download that because you can't just get the old enterprise manager any more.  There are also a number of third-party tools you can use if you want to try googling around for them.
0
 
LVL 18

Expert Comment

by:jcoehoorn
ID: 20375801
Oh, when you get it installed and connected, you should know that a lot of the functionality of this program is provided by context menus you get when right-clicking on the various items in the tree on the left side.
0
 

Author Comment

by:Pizpot
ID: 20375946
is the express version to get?
0
 

Author Comment

by:Pizpot
ID: 20376189
oh what the heck, accepted. I am in a good mood and it is working. I'll ask again for code later. Thanks eh.
0
 
LVL 18

Expert Comment

by:jcoehoorn
ID: 20376229
Sorry, had to step away for a bit- yes, express will be fine for now.  You can't do some things with, like import new data, but for now you just want to explore.
0
 

Author Comment

by:Pizpot
ID: 20376384
jcohoorn,

I wish it would let me find the text I am looking for but it says no file to look in. Do I need to sql query? how do you do that when you don't know the column name you are looking for?
0
 
LVL 18

Expert Comment

by:jcoehoorn
ID: 20376401
Once you've established a connection, you can browse with the object explorer.  Make sure it's visible by choosing View->Object Explorer from the menu.  Then you can use the tree to pull down tables in your database, and columns within tables.  Right-click to see available operations.
0
 

Author Comment

by:Pizpot
ID: 20376439
Oh I see the tables alright, just not anyway to find a data string. :-( Opening and viewing each table is not what I want.
0
 
LVL 18

Expert Comment

by:jcoehoorn
ID: 20376735
You should be able to see column names and datatypes in the object explorer.  To see actual data in the table right click on a table and choose "Open Table", or choose "New Query" from the toolbar, make sure the correct database is selected, and use "SELECT * FROM <TableName>" for your query.
0
 

Author Comment

by:Pizpot
ID: 20383379
Thanks, you've now earned your keep for sure.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need help making a program or form for inventory that exports to txt 8 43
VB.Net - TypeInitializer Error 25 32
write xml in vb.net 2 32
Passing data between Forms 3 20
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
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…

839 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