• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

DB with 700 tables and no documentation or source code help

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
Pizpot
Asked:
Pizpot
  • 7
  • 6
1 Solution
 
Joel CoehoornDirector of Information TechnologyCommented:
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
 
PizpotAuthor Commented:
I am going there now, and that might satisfy me, but I know I'll need code for such operations soon enough.
0
 
PizpotAuthor Commented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Joel CoehoornDirector of Information TechnologyCommented:
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
 
Joel CoehoornDirector of Information TechnologyCommented:
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
 
PizpotAuthor Commented:
is the express version to get?
0
 
PizpotAuthor Commented:
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
 
Joel CoehoornDirector of Information TechnologyCommented:
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
 
PizpotAuthor Commented:
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
 
Joel CoehoornDirector of Information TechnologyCommented:
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
 
PizpotAuthor Commented:
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
 
Joel CoehoornDirector of Information TechnologyCommented:
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
 
PizpotAuthor Commented:
Thanks, you've now earned your keep for sure.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now