Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE Temp ON PRIMARY(
- NAME = Temp
- , FILENAME = 'C:\Temp.mdf'
- , SIZE = 2MB
- , FILEGROWTH = 10%)
- LOG ON (
- NAME = Temp_Log
- , FILENAME = 'C:\Temp.ldf'
- , SIZE = 1MB, MAXSIZE = 70MB
- , FILEGROWTH = 10%)
- public void AcuConvert()
- {
- using (DestD)
- {
- SqlCommand command = new SqlCommand();
- DestD.Open();
- command.Connection = DestD;
- foreach (var item in Entity.SqlDestinationQueries.ToList())
- {
- command.CommandText = item.Query;
- command.ExecuteNonQuery();
- }
- foreach (var item in Entity.SystemQueries.ToList())
- {
- command.CommandText = item.Query.Replace("@Sys", SysD.Database);
- command.ExecuteNonQuery();
- }
- foreach (var item in Entity.InsertQueries.ToList())
- {
- command.CommandText = item.Query.Replace("@Source", SourceD.Database); ;
- command.ExecuteNonQuery();
- }
- }
- }
Add Comment
Please, Sign In to add comment