Activity overview
Latest activity by noobix
There are no duplicate files in the folder structure.
I didn't make any copies of the files there I didn't even touch them.
Maybe this is an application bug or maybe I'm doing something wrong,
right know I don't know what else to try.
As I said I'm not allowed to send you a DB snapshot.
Could you please provide me with an accurate step-by-step guide what to do create some baseline scripts of an production DB and use them in the development process? What I've been trying to do in the last days was following the steps you guys explained in the document describing the various DB development techniques. We finally decided to go for method #2 (subversion edit-commit style). / comments
There are no duplicate files in the folder structure.
I didn't make any copies of the files there I didn't even touch them.
Maybe this is an application bug or maybe I'm doing something wrong,
righ...
Hi Michelle,
I don't think I'm using different case sensitivity settings, I exported the DB as it is: SQL_General_Latin1_CI_AS.
After the export to the script folder the XML file there contains the same case sensitivity setting.
Is that as it's supposed to be, isn't it?
The script folder cannot even be compared to itself every time I try the message "A duplicate object..." pops up.
I'm quite confused right now and don't know what's going on with this tool.
We just cannot put this baseline script folder under source control due to nobody would then be able to sync. against it.
We definitely need these baseline scripts to continue our DB development process.
Unfortunately I can't send you the scripts due to I'm not allowed to.
Maybe you have other suggestions for me what to do?
Regards,
Tino / comments
Hi Michelle,
I don't think I'm using different case sensitivity settings, I exported the DB as it is: SQL_General_Latin1_CI_AS.
After the export to the script folder the XML file there contains the...
SQLCompare aborts comparing process
Using SQLCompare I have exported our production DB to a script folder (baseline scripts).
After that I made some schema changes and tried to compare the changes against the original scripts.
SQLCom...
Hi David,
a DML script (or more) including many INSERTs is definitely the right solution for us. This is how we populate our DB now.
We'd like a similar feature as in DBGhost Data and Schema Scripter.
This tool can script both the static data and the schema in single SQL scripts.
SQLCompare can do the same but without scripting the static data.
That would be a nice-to-have feature.
Regards,
Tino / comments
Hi David,
a DML script (or more) including many INSERTs is definitely the right solution for us. This is how we populate our DB now.
We'd like a similar feature as in DBGhost Data and Schema Script...
nobody can give me an answer? / comments
nobody can give me an answer?
populating lookup tables
Hi,
I'm not sure whether this is the right forum, I didn't know which one to post my question in.
My question is what is the best/recommended practice (using redgate tools) to populate lookup table...
"At any point in the sync." would be nice to have. Anyway I guess for the most scenarios a before-/after-sync event should be enough.
For now I should stick with the command line version, integrate it in our DB deployment scripts and run some custom scripts (security/permissions) after the sync. Is that what you'd recommend me?
By the way, does the command line tool return a DOS errorlevel?
Is there any documentation for that (and the command line features) excepting "sqlcompare.exe /?"? / comments
"At any point in the sync." would be nice to have. Anyway I guess for the most scenarios a before-/after-sync event should be enough.
For now I should stick with the command line version, integrate...
1) just manually running things in Management Studio before and after pressing the finish button on the synchronization wizard
This is not an option for us due to our batch file based deployment process.
2) saving the synchronization script and prepending / appending scripts to it, then running the combined version
This is a possible way to add custom code to the generated script.
3) creating a batch file which runs the scripts before and after using the command line SQL Compare synchronization.
I think this is the way to go for us, this option might give us the most flexibility. I just have to figure out how to use the command line version of SQL Compare. Does it offer all the features the UI version does?
As for your question about the pre-/post-sync script advantages I'd say you're right when saying "...more control over the process...". This could be the main benefit (besides more flexibility) of an event-driven system. / comments
1) just manually running things in Management Studio before and after pressing the finish button on the synchronization wizard
This is not an option for us due to our batch file based deployme...
Hi Michelle,
thank you for the solution. I was able to sync the prod. DB without the users/memberships although after that I lost - as you mentioned - the security permissions.
This is certainly a better aproach to export a live DB than using the application's "Export data source" feature. A nice-to-have feature extension for upcoming releases would be a filter option (similar to the existing one) that makes it possible to select the object types to include in the export.
Regarding the possibility to change the security permissions after sync. I would suggest some kind of sync. event system (before-sync, after-sync, etc.). This could be an useful mechanism to highly customize the sync. process. That way a developer could write some custom T-SQL scripts and hook them into the event system when needed. As a matter of course those scripts must be executed against the DB engine at the appropriate time.
For example I'd write a custom script to dynamically add/create the appropriate user(s)/login(s)/permission(s) depending on the server that's being sync.
Please let me know what you guys think about this suggestion.
I assume as with SQL Compare 6 is not possible to run some custom T-SQL script (against the DB engine) after the sync., is it?
Tino / comments
Hi Michelle,
thank you for the solution. I was able to sync the prod. DB without the users/memberships although after that I lost - as you mentioned - the security permissions.
This is certainly a ...
comparing/sync security objects: user/role/schema
Hello,
at the moment I'm evaluating your current SQL Compare release.
First I used the function "Export data source" to export our production DB to a sql script folder structure. Everything worked ...