Solved

DB with 700 tables and no documentation or source code help

Posted on 2007-11-29
13
158 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
[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
  • 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Data organization issue 7 55
Trying to Create FTP Client in VB.net - getting errors 3 36
Read oracle BLOB in vb.net 2 24
VB .net 2010 Byte array 2 21
This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

732 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