sort by Date Last Modified

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

sort by Date Last Modified

Postby lkalman@financemgr.com » Fri Aug 31, 2012 5:14 pm

Looking to add a column on the object to be able to
sort by Date Last Modified
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Postby andy.campbell.smith » Mon Sep 03, 2012 12:25 pm

Sorry - I'm not sure exactly how this relates to SQL Compare? If you want to order rows in a table by the date last modified, you'd need to set that up through SSMS - there's a little more information here that might be useful to you:

http://stackoverflow.com/questions/2610 ... sql-server

Is that the kind of thing you're after?
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

sort by Date Last Modified

Postby lkalman@financemgr.com » Thu Sep 06, 2012 8:04 pm

Well this way you can sort by date order and determine which change you want per date.

For Example if you are only looking to find out today's changes and not all other changes.
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Postby andy.campbell.smith » Thu Sep 13, 2012 2:51 pm

Ah, right, OK. SQL Server doesn't capture any information like this by default, so you'd need to set up a computed column for SQL Compare or SQL Data Compare to have any access to that information. I'm assuming this question is actually about SQL Data Compare, given that you're talking about sorting by columns.

If you've got that DateModified column set up, then you can filter the data with a WHERE clause as detailed on this page:

http://www.red-gate.com/supportcenter/C ... Conditions

That ought to let you filter for changes applied within a specific timeframe. Does that help at all?
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: grinnell and 0 guests