![]() Is thisĬorrect? I must admit that I do need to analyse this situation more exactly to reassure myself that it will work in our situation. However, I assume that I need to connect to a copy of the client's database that corresponds to the deployed targetmodelfile dbschema file. We do not always have access to the client database and so a direct db connection to this is not possible. in my case the development database rather than the production one). Tentative conclusion that my connection string points to the wrong database (ie. I have also had the above mentioned refactorlog problem and have come to the I was initially also confused as to why I have to have a db-connection when comparing 2 xml-based (dbschema) files. I compare 2 dbschema files using VSDBCMD.exe on a daily basis. Why is the TargetConnectionString needed when comparing two dbschema files, when there in theory shouldn't be I guess the absense of the TargetConnectionString in the deploymanifest is the cause to this error message, but I'm confused as to why. I only create a script, I don't deploy it from VS. This is probably because I haven't defined any connection string in the project properties. My deploymanifest has no TargetConnectionString, or anything that looks like a ConnectionString. This leads me to the TargetConnectionString in the deploymanifest. *** The ConnectionString property has not been initialized.Īpparently my command line was not the issue. I tried to adapt my command line to what you suggested, but it gave me the same error message: Please remember to mark the replies as answers if they help and unmark them if they provide no help If you have any feedback on our support, please contact msdnmg deploymanifest file is correct.Įdwer Fang MSDN Subscriber Support in Forum So you should make sure the value of the property TargetConnectionString in the. In addition, according to the error message it seems that you didn’t set value to the connection string correctly. ![]() Vsdbcmd.exe /a:deploy /dd:- /dsp:sql /model:ProjectName.dbschema /targetmodelfile:TargetDatabase.dbschema /DeploymentScriptFile:OutputFilename.sql /ManifestFile:ploymanifest /p:TargetDatabase="TargetDatabaseName" What’s the command line statements you are using to do the schema compare? I think your command line statements should be similar to the followings. ![]() I did a research on my PC, I compared two database projects and they both have a refactorlog file, I successfully compared these schemas and Based on my understanding, I don’t think the refactorlog file causes the failure of schema comparation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |