Comments
Sort by recent activity
Using VSTS it's possible to query the histories also parametrising the query itself. However I don't know what's your one. / comments
Using VSTS it's possible to query the histories also parametrising the query itself. However I don't know what's your one.
hey @ipelly you can navigate the history of your souce control manager (git? TFS/VSTS? svn?) / comments
hey @ipelly you can navigate the history of your souce control manager (git? TFS/VSTS? svn?)
The same for me. Tried and got GETDATE() on the default render. / comments
The same for me. Tried and got GETDATE() on the default render.
I'd like to wait to update actually, because of my team needs. That said, I cannot get the dates. I'm still getting the GETDATE() layout. CREATE TABLE foo (dd datetime);
GO
INSERT INTO dbo.foo (dd)
VALUES
(GETDATE() -- dd
)
What is the version of your SQL Server? / comments
I'd like to wait to update actually, because of my team needs. That said, I cannot get the dates. I'm still getting the GETDATE() layout.CREATE TABLE foo (dd datetime);
GO
INSERT INTO dbo.foo (dd)...
My version is actually a frequent update version. If you upgrade I don't know if you'll find out it. / comments
My version is actually a frequent update version. If you upgrade I don't know if you'll find out it.
hey ABarthen,
what is the SQL Prompt version you're speaking of? When I write the INSERT statement the default value for datetimes is GETDATE() right now (SQL Prompt 9.1.1.4243). / comments
hey ABarthen,
what is the SQL Prompt version you're speaking of? When I write the INSERT statement the default value for datetimes is GETDATE() right now (SQL Prompt 9.1.1.4243).
Hi @...,
as far as I know, nothing but comparing MSDB database. But I strongly suggest to avoid that way. What about using this tool instead? / comments
Hi @...,
as far as I know, nothing but comparing MSDB database. But I strongly suggest to avoid that way. What about using this tool instead?
Hi @Ivar,
speaking about sharing stuff across RedGate tool is actually a trend topic in latest weeks ;-)
I hope to get everything under a "central" point, but, until then, I've moved those files (not just tabs, but also coding styles and so on) under source control, in a certain folder. Then, I've changed the default path of each tool in order to read from that source controlled path, and that's it.
If you don't have default paths or if you cannot change the path setting, you can use powershell (or similar) in order to automate the copy of that file (from your machine for instance) into the source control. Then, when you get, you can execute another posh that synchronize each member of the team.
It's just a big picture, 'cause I really want to share with you the automation/devops "approach". Then you can choose everything you consider into your comfort zone.
cheers,
ale / comments
Hi @Ivar,
speaking about sharing stuff across RedGate tool is actually a trend topic in latest weeks ;-)
I hope to get everything under a "central" point, but, until then, I've moved those files (n...
hi jrbrown00,
did you mean SQL Compare (not SQL Data Compare)?
anyway, you can exclude objects using filters: https://www.red-gate.com/hub/product-learning/sql-compare/sql-compare-custom-filters
hope this helps / comments
hi jrbrown00,
did you mean SQL Compare (not SQL Data Compare)?
anyway, you can exclude objects using filters: https://www.red-gate.com/hub/product-learning/sql-compare/sql-compare-custom-filters
ho...
hi @...,
not by design. But you can automate the process using the command lines as described here:
SQL Compare command line
Sql Data Compare command line
/ comments
hi @...,
not by design. But you can automate the process using the command lines as described here:
SQL Compare command line
Sql Data Compare command line