65.9K
CodeProject is changing. Read more.
Home

SMO 101 - Getting all DB's

starIconstarIconstarIconstarIconstarIcon

5.00/5 (2 votes)

Aug 17, 2011

CPOL
viewsIcon

17292

How to get a quick list of all DBs using SMO

To get all the DB's programatically on a local instance of SQL Server using SMO.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;

namespace ConsoleApplication1
{
    class Program
    {       
        static void Main(string[] args)
        {
            Server s = new Server(".\\INSTANCENAME");
            foreach (Database d in s.Databases)
            {
                Console.WriteLine(d.Name.ToString());
            }
            Console.ReadKey();
        }
    }
}

Points of Interest

Don't forget to add the references via Project >> Add Reference... >> Browse tab