SQL Server Forums - Export Database Names to a File

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Administration

Export Database Names to a File

New Topic

Reply to Topic

Printer Friendly

Author

Topic

afifimk
Starting Member

USA
19 Posts

Posted - 05/04/2012 : 11:45:42

I have many databases and want to export the database names only to an external file (Excel, etc.). I can do this manually but it will take a long time because I have hundreds of databases and most of them have a unique GUID appended to the name. I am just looking for an easy way to get this done.

robvolk
Most Valuable Yak

USA
15558 Posts

Posted - 05/04/2012 : 11:50:12

Using the command line:

bcp "select name from sys.databases where database_id>4" queryout databases.csv -Sserver -T -c

Change "server" to match your SQL Server's name.

visakh16
Very Important crosS Applying yaK Herder

India
47040 Posts

Posted - 05/04/2012 : 18:25:02

you mean all those hundreds of databases are in same server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

afifimk
Starting Member

USA
19 Posts

Posted - 05/09/2012 : 12:20:59

It appears that I exaggerated the number a little bit. There are only 49 DB's. SharePoint creates a lot of DB's.

jackv
Flowing Fount of Yak Knowledge

United Kingdom
1767 Posts

Posted - 05/09/2012 : 15:10:37

SQLCMD -E -S MY_SERVER_NAME -Q "select name from sys.databases where database_id>4" -o my_output_file.txt

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.