jwcolby
jwcolby at colbyconsulting.com
Mon Jun 11 10:09:12 CDT 2007
No, I mean programmatically. Basically I am looking to populate a combo with servers, then when I select a server, populate a combo with databases, select a database, populate a combo with tables etc. I am writing an application for the import / export / import of data. Flat files into SQL Server, data back out to "CSV" for address validation, data back in from CSV. ATM I am hard coding all the locations but eventually I must get this thing more automated so I am just boning up on how to browse through database objects. I am looking at code right now for the SQLDMO object which looks like it will serve the purpose. It is not part of .NET but I can reference it from my project. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Monday, June 11, 2007 10:55 AM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] Get list of servers, databases and tables in a database View menu, Server Explorer. Charlotte -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, June 11, 2007 6:49 AM To: dba-vb at databaseadvisors.com; dba-sqlserver at databaseadvisors.com Subject: Re: [dba-VB] Get list of servers, databases and tables in a database I forgot to specify that I am using VB.Net for this. So I need to know how to do all this inside of VB.Net. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, June 11, 2007 9:26 AM To: dba-sqlserver at databaseadvisors.com; dba-vb at databaseadvisors.com Subject: [dba-VB] Get list of servers, databases and tables in a database I need to allow a user (me) to navigate through my servers, databases and tables in databases to select a specific table, for example to export to CSV. Does anyone know how to determine instances of database servers, then get lists of databases in those servers, then get tables in a specific database? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com