May 28, 2014 at 4:44 am
Hi,
I want to compare the database structures(columns,datatypes..etc) across same databases located in different servers. Can you please let me know how we can achieve this?
Thanks in advance.
May 28, 2014 at 7:07 am
smriti.subramanian (5/28/2014)
Hi,I want to compare the database structures(columns,datatypes..etc) across same databases located in different servers. Can you please let me know how we can achieve this?
Thanks in advance.
Red Gate has an awesome tool for this that can be found http://www.red-gate.com/products/sql-development/sql-compare/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 28, 2014 at 8:17 am
Another vote for the RedGate SQL Compare tools.
Nice license plate Jason S.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 28, 2014 at 8:56 am
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third parties out there if you prefer to shop around.
My license plate is SQLGuru! 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 28, 2014 at 9:20 am
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third parties out there if you prefer to shop around.
My license plate is SQLGuru! 🙂
Sweet
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 28, 2014 at 12:41 pm
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third parties out there if you prefer to shop around.
My license plate is SQLGuru! 🙂
Sweet
Yeah - right up until the yahoos here in Alabama come up and ask me "do you rescue baby squirrels??" (or some variant dealing with squirrels)!! That has happened three times now, usually in the Wal-Mart parking lot! :w00t:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 28, 2014 at 4:56 pm
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third parties out there if you prefer to shop around.
My license plate is SQLGuru! 🙂
Sweet
Yeah - right up until the yahoos here in Alabama come up and ask me "do you rescue baby squirrels??" (or some variant dealing with squirrels)!! That has happened three times now, usually in the Wal-Mart parking lot! :w00t:
I get the same squirrel comments with my plates too. Smile and Wave, Smile and Wave.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 28, 2014 at 5:34 pm
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third parties out there if you prefer to shop around.
My license plate is SQLGuru! 🙂
Sweet
Yeah - right up until the yahoos here in Alabama come up and ask me "do you rescue baby squirrels??" (or some variant dealing with squirrels)!! That has happened three times now, usually in the Wal-Mart parking lot! :w00t:
I get the same squirrel comments with my plates too. Smile and Wave, Smile and Wave.
As do I. :-/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 28, 2014 at 7:36 pm
Jason Selburg (5/28/2014)
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third parties out there if you prefer to shop around.
My license plate is SQLGuru! 🙂
Sweet
Yeah - right up until the yahoos here in Alabama come up and ask me "do you rescue baby squirrels??" (or some variant dealing with squirrels)!! That has happened three times now, usually in the Wal-Mart parking lot! :w00t:
I get the same squirrel comments with my plates too. Smile and Wave, Smile and Wave.
As do I. :-/
I don't understand how SQL becomes SQRL. It's nice to hear it doesn't just happen to me.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 30, 2014 at 11:52 am
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third parties out there if you prefer to shop around.
My license plate is SQLGuru! 🙂
Both "SQL DBA" and "SQL Guru" are excellent plates!
I would pick "SQL DRIVR" (get it?) if I had a car. :hehe:
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply