SQL tools for updating data
-
Are there any tools that come with SQL Server which can be used to check differences between data, and then do the merge? Specifically I need something which reports the data differences and allows me to automate the process of rolling data on a development server into a production environment.
Any feedback would be appreciated.
Thanks.
Jim
-
If you don't mind spending a tiny sum see SQL Data Compare :
http://www.red-gate.com/sql/summary.htm
As for built in that come with SQL Server, there are none that I know of.
Tim C.
//Will write code for food
One Windows to rule them all, One Windows to find them,
One Windows to bring them all and in the darkness bind them
In the Land of Microsoft where the Shadows lie.
Edited by - tcartwright on 01/22/2003 11:25:32 AM
Tim C //Will code for food -
Data Compare is decent, I've got a review up if you want to look into it more. Downside is that it doesn't do text columns. They let you download a free eval, worth a try, nice guys at RedGate (and a loyal sponsor!).
Andy
-
I defer to your experience with SQL Data Compare. I only used it till my
shareware on it ran out. We have been using the SQL Compare product for about a
year now, and couldn't be happier with it. It has some issues, but for us to do
the same thing would have been a tremendous task..... We have these issues /
wishes for SQL Compare:
1) Capability to re-arrange the scripting order from the GUI
2) Capability to mark objects as IGNORABLE. Some admin scripts we don't want
shipped to the client, of course you can manually mark these, but then you have
to remember every time.
3) Way to set certain actions to be performed at the end of the script. IE run a
permissions script, net send, etc....
What do you think Andy?
Oh - Nice job on your review btw, I did a review of SQL Compare here recently.
Although I am just a code slinger masquerading as a DBA.....
Tim C.
//Will write code for food
One Windows to rule them all, One Windows to find them,
One Windows to bring them all and in the darkness bind them
In the Land of Microsoft where the Shadows lie.
Tim C //Will code for food
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply