[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

DB with 700 tables and no documentation or source code help

Posted on 2007-11-29
13
Medium Priority
?
162 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:
Joel Coehoorn earned 1500 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 18

Expert Comment

by:Joel Coehoorn
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:Joel Coehoorn
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:Joel Coehoorn
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:Joel Coehoorn
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:Joel Coehoorn
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

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.

Question has a verified solution.

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

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…
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

831 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