Comments
Sort by recent activity
Yeah (not), my trial has expired
hopefully I don't need to use it yet
but let's hope I'll see 7 soon before I have to revert back to 6 :P / comments
Yeah (not), my trial has expired
hopefully I don't need to use it yet
but let's hope I'll see 7 soon before I have to revert back to 6 :P
Just to follow up on that question, my SQL Compare 7 Beta says it has 20 days left until the trial ended
Will we see the official SQL Compare 7 before that ends?
We do own license for SQL Toolbelt, but it's so hard to go back to SQL Compare 6 now, because 7 is so good [image] / comments
Just to follow up on that question, my SQL Compare 7 Beta says it has 20 days left until the trial ended
Will we see the official SQL Compare 7 before that ends?
We do own license for SQL Toolbelt,...
good point, I just ran into that issue this morning
not a big blocker though, just means I have to fix either the first few lines, or the last few lines / comments
good point, I just ran into that issue this morning
not a big blocker though, just means I have to fix either the first few lines, or the last few lines
I agree, SQL Backup doesn't read from SQL 2005's default Database file paths that's configured in Server Properties
but either way, I just copy & paste SQL Backup's restore script, and modify it on my own (find & replace) EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE [XXX] FROM DISK = ''D:\Backups\XXX.sqb'' WITH RECOVERY, MOVE ''XXX'' TO ''D:\SQLData\XXX.mdf'', REPLACE"'
GO
/ comments
I agree, SQL Backup doesn't read from SQL 2005's default Database file paths that's configured in Server Properties
but either way, I just copy & paste SQL Backup's restore script, and modify it on...
It is certainly not a major annoyance, or a "blocker" in anyway
and normally it shouldn't happen often either in a usual single-DB product
However, we have 6 DBs related to our product
and we employ Agile/Scrum for 2-weeks sprint, so every sprint release I'd need to compare all 6 DBs in theory to synchronize with Production
In reality, we usually only update 3~4 DBs
but that means my Comparison Objects is filled with those 3~4 DBs
where if I can do it in 1 project........ Hallelujah!
Sometimes I have to change the project destination servers too
e.g.
Development vs. UA/QA
Development vs. Staging
Development vs. Production
Thanks for hearing us out... it'd be nice to have, IF it's easy
But since it isn't trivial, I can wait.
I need the USE DB_NAME statement more than this [image]
which is included in SQL Compare 7.0 RTM right? / comments
It is certainly not a major annoyance, or a "blocker" in anyway
and normally it shouldn't happen often either in a usual single-DB product
However, we have 6 DBs related to our product
and we emplo...
You can also directly compare the table size to pinpoint
It could be the unreleased space, or the index EXEC sp_msforeachtable 'sp_spaceused "?"'
/ comments
You can also directly compare the table size to pinpoint
It could be the unreleased space, or the indexEXEC sp_msforeachtable 'sp_spaceused "?"'
I am fine with not showing IDENTITY column during an insert :P
At least if one needs to insert manually into that column, they have to do some work (add in the column name, set identity insert on/off, etc...), intentionally / comments
I am fine with not showing IDENTITY column during an insert :P
At least if one needs to insert manually into that column, they have to do some work (add in the column name, set identity insert on/o...
Nope
I have views under different schemas, names, and SQL Prompt 3.8 picked them up fine, with a different icon than Tables in the prompt popup
Delete all cache and try again? / comments
Nope
I have views under different schemas, names, and SQL Prompt 3.8 picked them up fine, with a different icon than Tables in the prompt popup
Delete all cache and try again?
That's an interesting and good idea, store data contents in text and SourceControl it
For that purpose, I would say TEXT > INSERT/DML
but obviously when there's the need to INSERT, obviously having INSERT is nice - but I thought that's why Data Compare exists in the first place - you hit a button and it synchronizes data for you, without the need for INSERT statement
I forgot now, doesn't Data Compare generate a script like SQL Compare? which will be purely INSERT if you compare with empty database / comments
That's an interesting and good idea, store data contents in text and SourceControl it
For that purpose, I would say TEXT > INSERT/DML
but obviously when there's the need to INSERT, obviously having...
SQL Refactor hangs up my SSMS, so I have uninstalled it and am happy with SQL Prompt 3.8 (all I need is Layout function really)
I agree they share a similar path though, and SQL Refactor hasn't been updated in a while / comments
SQL Refactor hangs up my SSMS, so I have uninstalled it and am happy with SQL Prompt 3.8 (all I need is Layout function really)
I agree they share a similar path though, and SQL Refactor hasn't bee...