HYTOS

using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.IO;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace DataBaseCreate

{

    class Program

    {

        static void Main(string[] args)

        {

            foreach (var item in args)

            {

                RunSql(item);

            }

            Console.ReadKey();

        }

        static void RunSql(string filePath)

        {

            string connectionString = Properties.Settings.Default.ID2Manager; // 데이터베이스 연결 문자열 입력

            string sqlContent = File.ReadAllText(filePath);

            using (SqlConnection connection = new SqlConnection(connectionString))

            {

                connection.Open();

                string[] sqlCommands = sqlContent.Split(new[] { "GO" }, StringSplitOptions.RemoveEmptyEntries);

                foreach (string sqlCommand in sqlCommands)

                {

                    using (SqlCommand command = new SqlCommand(sqlCommand, connection))

                    {

                        try

                        {

                            command.ExecuteNonQuery();

                            Console.WriteLine("SQL command executed successfully.");

                        }

                        catch (Exception ex)

                        {

                            Console.WriteLine("Error executing SQL command: " + ex.Message);

                        }

                    }

                }

                Console.WriteLine($"{filePath} file executed successfully.");

            }

        }

    }

}