I have written following lines of code, but when TransferData() method is called, it generates error "Property LoginSecure cannot be changed or read after a connection string has been set."
Can anybody help me? Thanks in advance....
Code:
//1. Create Transfer Object
Transfer transObj = new Transfer();
//transObj=new Transfer(server.Databases[fromdatabasename]);
transObj.DestinationLoginSecure = false;
transObj.DestinationLogin = "sa";
transObj.DestinationPassword = "test";
//Set Destination Server//Build a "serverConnection" with the information of the "sqlConnection"
destSrvCon =
new ServerConnection(sqlCon);
//The serverConnection is used in the ctor of the Server.
destServer = new Server(destSrvCon);
transObj.DestinationServer = destServer.Name.ToString();
//2. Define Transfer Object's Properties
transObj.Database = server.Databases["Aworks"];
transObj.DestinationDatabase = "AWorksCopy";
transObj.Options.WithDependencies =true;
transObj.Options.ContinueScriptingOnError = true;
transObj.CopySchema = true;
transObj.CopyData = true;
transObj.CopyAllTables = true;
//4. Finally Transfer Data
transObj.TransferData();
//transObj.ScriptTransfer();
I got this error as well, and have tried everything to avoid it. The only explanation I have left is that I'm using server 2000. Is this what you're using Ritesh?
|||I got this error as well. I changed the file permissions on the ReplData folder and it went away.|||
i get this same error.
did you guys resolve the problem?
ReplData folder? only folder i can think of is the folder where the database files are stored....
