Hi Murugappan,
Use DatabaseName,Username and password to check the connection by passing it with connection string,
If connection is successful then use the below query to fetch the details about database
USE DatabaseName;
SELECT * FROM sys.objects WHERE type_desc LIKE '%FUNCTION%' OR type_desc IN ('USER_TABLE','SQL_STORED_PROCEDURE','VIEW') order by type_desc asc;
the above query will fetch all details that belongs to the Database given
If you want to fetch on category based then you can make use of the below queries
USE DatabaseName;
SELECT * FROM sys.tables
SELECT * FROM sys.procedures
SELECT * FROM sys.views
SELECT * FROM sys.objects WHERE type_desc LIKE '%FUNCTION%';
Once fetched you can export it into Excel using server side code.You can refer
here[
^] for this.
Hope this helps you a bit.
Regards,
RK