Guest User

Untitled

a guest
Jan 16th, 2019
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. CREATE DATABASE Temp ON PRIMARY(
  2. NAME = Temp
  3. , FILENAME = 'C:\Temp.mdf'
  4. , SIZE = 2MB
  5. , FILEGROWTH = 10%)
  6. LOG ON (
  7. NAME = Temp_Log
  8. , FILENAME = 'C:\Temp.ldf'
  9. , SIZE = 1MB, MAXSIZE = 70MB
  10. , FILEGROWTH = 10%)
  11.  
  12. public void AcuConvert()
  13. {
  14. using (DestD)
  15. {
  16. SqlCommand command = new SqlCommand();
  17. DestD.Open();
  18. command.Connection = DestD;
  19. foreach (var item in Entity.SqlDestinationQueries.ToList())
  20. {
  21. command.CommandText = item.Query;
  22. command.ExecuteNonQuery();
  23. }
  24. foreach (var item in Entity.SystemQueries.ToList())
  25. {
  26. command.CommandText = item.Query.Replace("@Sys", SysD.Database);
  27. command.ExecuteNonQuery();
  28. }
  29. foreach (var item in Entity.InsertQueries.ToList())
  30. {
  31. command.CommandText = item.Query.Replace("@Source", SourceD.Database); ;
  32. command.ExecuteNonQuery();
  33. }
  34.  
  35. }
  36. }
Add Comment
Please, Sign In to add comment