Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
IncludeIfNotExist in trigger
jayakrishnan Morayur
Mar 12 2011 4:36 AM
1.8k
Reply
conServer =
new
Server
(
new
ServerConnection
(mySQlCon));
Database
db = conServer.Databases[cmbDatabase.Text];
Transfer
t =
new
Transfer
(db);
ScriptingOptions
scriptOp =
new
ScriptingOptions
();
Server db.DatabaseOptions.RecursiveTriggersEnabled =
true
;
t.CopyAllObjects =
true
;
t.DropDestinationObjectsFirst =
true
;
t.CopySchema =
true
;
t.CopyData =
true
;
t.DestinationServer =
true
;
t.CopyAllDatabaseTriggers =
true
;
t.Options.Triggers =
true
;
t.Options.IncludeIfNotExists =
true
;
StringCollection
commands = t.ScriptTransfer();
StringBuilder
sb =
new
StringBuilder
();
i'am generate script above way
but the script of stored procedure and table are includeIfNotExists statment but trigger not includeIfNotExist statment why?
Attachment:
scriptgenerate.zip
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Get next datagridrow
Reading from excel sheet to visual c# datagridview using excel object library