Exemple #1
0
        public void Debug()
        {
            string query = @"
                    select top 100 * from[Database].[Schema].[Table] inner join[Database].[Schema].[Table]
                    on[Database].[Schema].[Table].[Field] = [Database].[Schema].[Table].[Field]
                    where[Database].[Schema].[Table].[Field] = 'Value'
                    ";


            string scriptsDir = @"C:\Users\user\Desktop\localdb\Database\_Data";

            string       server       = "someServer";
            string       database     = "database";
            string       configServer = "configServer";
            DataExporter dataExporter = new DataExporter(server, database, configServer, "localdatabase");

            dataExporter.ExportDataToScripts(query, scriptsDir, DatabaseDevelopment.Enums.DataScriptType.Test, DatabaseDevelopment.Enums.SqlScriptType.Merge, true, true, true, "Test");
        }