User profile for rgribble

If it helps, i too think these would be useful features And surely it cant be that hard to just make the colum,n header a different shaded colour, if one or more records has a discrepancy in that column A way to sort them to the top would also be nice, as the OP suggested, this would enhance productivity when wanting to look through all of the records that had a difference in the "Total Cost" field (as an example) / comments

If it helps, i too think these would be useful features And surely it cant be that hard to just make the colum,n header a different shaded colour, if one or more records has a discrepancy in that c...

0 votes

I think there may be some confusion over terms here... i have noticed alot of people say "check out" when they arent actually checking out a file to edit it... they really should say "synch" or "get". The idea of using SQL Compare 6's new script folder abilities to "build" a database is one i am looking forward to as well... like Granted, i have an inhouse build routine which essentially takes all of the database scripts and "builds" them into an empty staging database, that can then be snapshotted and/or used as a source to synchronise schema changes to a live DB. Currently my DB build is pretty dumb... it just uses a queued approach and hammers scripts at the staging database, if one fails it gets requeued at the end and tried later... It works for the most part but is ugly and inefficient. But i didnt want to get into the nitty gritty of actually interpretting the script files and figuring out some kind of dependancy order. I plan to change my build routine to create the empty database, then use SQL Compare 6 to compare the script folder source, to the empty database, and synchronise all changes across. I can let redgate worry about the dependancies and order that the objects need to be created! [image] We use the SQL Compare Toolkit edition (c# libraries to use in our .NET apps) to do this kind of thing here, but i believe that the "Pro" edition of SQLCompare supports commandline invocations as well, so that may be what you can do Granted. I agree with David, in terms of building a database from the scripts, no integration with source control on the part of RedGate itself is strictly necessary... most of us would probably have our existing build scripts or visual build applications like Visual Build Pro, FinalBuilder etc, anyway, and these can handle synching to the desired label/revisions of scripts and creating the empty database, before invoking redgate to do the actual "build". Then assumedly there are cleanup steps afterwards that our build script will do too. In my case this is comparing the built database to the snapshot stored in perforce, and if this is different checking out the snapshot and generating a new one ready to check back in. These tasks are accomplished by an application i wrote, which uses the SQLToolKit libraries / comments

I think there may be some confusion over terms here... i have noticed alot of people say "check out" when they arent actually checking out a file to edit it... they really should say "synch" or "g...

0 votes

in terms of integrating with source control, even a crude ability to "run commandline command for each object's script file" as it is synchronised, would help alot. Then, any source contrl system with a commandline interface could be called, to check the file out, or we could write our own script or program to do it... just tell us the filename, and we'll do the rest! only running it on the objects that are different and being synchronised would ensure a minimum of calls to the SCC system, only checking out files that are actually going to change Even batch file to be simply run before (to check all objects out), and after (to revert unchanged files) would be better than nothing In terms of incorporating it into settings, you could specify the commands at a project level, or perhaps at the application level, and each project just has a flag as to whether SCC commands should be run or not. / comments

in terms of integrating with source control, even a crude ability to "run commandline command for each object's script file" as it is synchronised, would help alot. Then, any source contrl system ...

0 votes

Related to this, i find it odd that if i type in a search string on the PRojects page, eg a server name, and then sort by a column (say datasource, or last compared date) I open a project and work ...

0 votes

Not sure if this post fell off the radar, but given there has been no official response, im bumping it [image] / comments

Not sure if this post fell off the radar, but given there has been no official response, im bumping it

0 votes

Yeah i understand... its just we hope for so much when we do these beta programs [image] Infact (and ive said this before), it would be really really good if RedGate could expand its idea of a beta program and deliver us at least ohne fo0llow up beta to the original, so we at least get a 2nd crack at it before the final version. I know it takes overhead to create a beta etc, but i think it would be worth it, and good to give those of us who had raised issues which are now apparently "fixed in the final release" to get another shot at testing it out for you guys, before it's too late! Regular beta updates would be even better... Im glad to hear that subfolders can be defined though, so that is a bonus. In terms of file naming, at least the default doesnt have square brackets in it anymore... apart from the file extensions, it actually matches what we are using here anyway (owner.object) / comments

Yeah i understand... its just we hope for so much when we do these beta programs Infact (and ive said this before), it would be really really good if RedGate could expand its idea of a beta progra...

0 votes

How is the suggestion to support wildcarded naming convention not flexible enough for practically ANY conceivable way someone would want it setup? Provide us some wildcards for server (%SN%), database (%DN%), owner (%OW%), object (%ON%) etc, and we could then format it how we want If you didnt have time to implement this, that's one thing... but to say you arent sure how to satisfy the majority... id like to know how the suggestion is not flexible enough to cater for nearly anyone's needs! Does this mean that although you will support reading in from a nested subfolder heirarchy, the scripts you enerate from scratch will be all dumped into a single folder? So not only do we have to rename them, but also have to then somehow sort them into their proper folders (which is hard/cumbersome when all you have is the object name, and a .sql extension - no easy way to tell one object type from another). I know ill be continuing to use my existing method of scripting files out, and just be using redgate to hopefully "build" into an empty staging database. A shame really [image] / comments

How is the suggestion to support wildcarded naming convention not flexible enough for practically ANY conceivable way someone would want it setup? Provide us some wildcards for server (%SN%), datab...

0 votes

hopefully that includes file extensions other than .sql files as well? / comments

hopefully that includes file extensions other than .sql files as well?

0 votes

Adding to these comments, it would be great if there could be options for how to name the scripts, and whether to create a subdirectory heirarchy underneath the given folder. Currently all scripts are created as [dbo].[object].sql I would prefer to name them without the brackets, and im sure others again would prefer not to have the dbo at all. I also dislike using .sql as the extension for everything... we use different extensions for different object types, such as .TAB for table, .PRC for stored proc, .UDF for function and so on (these file extensions come originally from enterprise manager, but we have extended/expanded this and defined our own extensions for 2005 objects too, such as ASM for assembly, SYN for synonym, XSC for XmlSchemaCollection etc). We also like to store our objects in subfolders root folder /Functions /StoredProcedures /Tables /Views and so on. I think ultimately you could provide users with a fair amount of flexibility by giving us a settings page allowing us to specify a file extension, and subfolder for each object type. This would allow users like Andrew to put all 200 objects in the root folder, and 2005 objects in a single subfolder, and having all files with a .sql extension, while allowing those like myself to configure a separate directory and file extension for each object type! There should also be a global option for the filename part of the scripts - should they contain the owner/schema, should they have square brackets, maybe they should all be prefixed with the database name and an underscore. This could be implemented in a similar way to the arguments field in the application options, when specifying a custom program to view SQL scripts, by using placeholders like %SO% for schema/owner, %ON% for object name, %DN% for database name etc [%SO%].[%ON%] = [dbo].[ObjectName] %DN%_%SO%.%ON% = Database_dbo.ObjectName etc... very flexible! Supporting these kind of options will make this new feature infinitely more usable to a larger amount of your users / comments

Adding to these comments, it would be great if there could be options for how to name the scripts, and whether to create a subdirectory heirarchy underneath the given folder. Currently all scripts ...

0 votes

I agree entirely. The sorting/searching etc options are great. I would also like to be able to copy/paste into the browse textbox, and to have the last sort order remembered between application executions Same deal with the browse dialog when choosing location of snapshot, or the folder to use as a "Scripts folder" datasource. Also when uysing the browse button for locating a folder to use as the scripts folder datasource, if you double click a folder that has no other folders inside it, perhaps it should select that folder and close the dialog, rather than then having to select "Back" then highlighting the folder in question and pressing the "Open" button (very annoying!). Or perhaps when in an empty folder, the Open button should still work, and will use the current folder. / comments

I agree entirely. The sorting/searching etc options are great. I would also like to be able to copy/paste into the browse textbox, and to have the last sort order remembered between application e...

0 votes

How can we help you today?

rgribble

Comments