How to get data from one server to another server?

First of all you need a access permission another server. ok if you have permission try this code

public List GetDatabaseList()
    {
        List list = new List();

        // Open connection to the database
        string conString = "server=xeon;uid=sa;pwd=manager; database=northwind";

        using (SqlConnection con = new SqlConnection(conString))
        {
            con.Open();

            // Set up a command with the given query and associate
            // this with the current connection.
            using (SqlCommand cmd = new SqlCommand("SELECT name from sys.databases", con))
            {
                using (IDataReader dr = cmd.ExecuteReader())
                {
                    while (dr.Read())
                    {
                        DataTable t = con.GetSchema(dr[0].ToString());
                    }
                }
            }
        }
        return list;

    }

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Joginder Banger12y ago
Accepted answer
First of all you need a access permission another server. ok if you have permission try this code

public List GetDatabaseList()
    {
        List list = new List();

        // Open connection to the database
        string conString = "server=xeon;uid=sa;pwd=manager; database=northwind";

        using (SqlConnection con = new SqlConnection(conString))
        {
            con.Open();

            // Set up a command with the given query and associate
            // this with the current connection.
            using (SqlCommand cmd = new SqlCommand("SELECT name from sys.databases", con))
            {
                using (IDataReader dr = cmd.ExecuteReader())
                {
                    while (dr.Read())
                    {
                        DataTable t = con.GetSchema(dr[0].ToString());
                    }
                }
            }
        }
        return list;

    }
0