-
Notifications
You must be signed in to change notification settings - Fork 1
/
Form1.cs
67 lines (56 loc) · 2.28 KB
/
Form1.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace SqlServerExport
{
public partial class MainForm : Form
{
public MainForm()
{
InitializeComponent();
}
private void ConnectButton_Click(object sender, EventArgs e)
{
try
{
Output.Text = "";
SqlConnection ServerConnection = new SqlConnection("user id=" + ServerUsername.Text + ";" +
"password=" + ServerPassword.Text + ";server=" + ServerHost.Text + ";" +
"Trusted_Connection=yes;" +
"database=" + ServerDatabase.Text + ";" +
"connection timeout=10");
ServerConnection.Open();
SqlCommand Command = new SqlCommand("SELECT * FROM sys.Tables", ServerConnection);
SqlDataReader Tables = Command.ExecuteReader();
List<string> TableNames = new List<string>();
while (Tables.Read())
{
TableNames.Add(Tables["name"].ToString());
}
Tables.Close();
foreach (string Table in TableNames)
{
Table T = new Table(Table, ServerConnection);
Output.Text += T.getCreateStatement() + Environment.NewLine + Environment.NewLine;
List<string> Inserts = T.GetInsertStatements();
foreach (string Insert in Inserts)
{
Output.Text += Insert + Environment.NewLine;
}
Output.Text += Environment.NewLine + Environment.NewLine;
}
MessageBox.Show("Done.");
}
catch (SqlException ex)
{
MessageBox.Show("An error occured when trying to connect. Please check the connection details.\n\n" + ex.Message);
}
}
}
}