SteveBell (2/10/2012)

---

I'd like to nominate Sean Lange for "Patient Retries Of The Same Explanation Over a Two Day Period" Award for today ...

http://www.sqlservercentral.com/Forums/Topic1249017-146-1.aspx"> http://www.sqlservercentral.com/Forums/Topic1249017-146-1.aspx

When I read the...

I'd like to nominate Sean Lange for "Patient Retries Of The Same Explanation Over a Two Day Period" Award for today ...

http://www.sqlservercentral.com/Forums/Topic1249017-146-1.aspx"> http://www.sqlservercentral.com/Forums/Topic1249017-146-1.aspx

When I read the OP,...

I use Embarcadero ER Studio Data Architect, (one of the ones Koen mentioned).

It reverse engineers from a database and has a number of features that I like.

Steve

Hi,

I just googled 'Crystal Report Forums' and it showed a bunch.

You could pick the one that suits you best.

Steve

SQLRNNR (1/20/2012)

---

Do them separate....

GilaMonster (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

---

GilaMonster (1/3/2012)

---

No, no, no, no, no!

And...

Jeff Moden (12/30/2011)

---

IMHO, Kimberly Tripp gives the most compelling reason to use an Integer-based PK and why it should usually be the the Clustered Index... performance. Please see the...

Ninja's_RGR'us (1/4/2012)

---

L' Eomot Inversé (1/4/2012)

---

Brandie Tarvin (1/4/2012)

---

Ninja's_RGR'us (1/4/2012)

---

Just got this ad on linked in!

Become an Oracle DBA in 24 Hours... call or mail <SNIP>

Not sure if this link will work...

Chuck Hottle (1/4/2012)

---

We recently had serious issues develop with just 90 days retention on one table in a busy database. The change table was 333 GB for a 31...

Hi,

Like you NJ-DBA, this doesn't 'feel right' to me either, mostly because of the way that CDC operates in the background.

I'll look for something with more meat on it, but...

You're all SQL heroes in my books!

Thank you for the help and the knowledge.

Happy Holidays

Steve

Dev (12/22/2011)

---

As you mention in your post that you selected some columns for table2 from table1. After reading your post it seems that your table1 get corrupted. Some...

Thanks!

Glad it worked out well.

Hi,

I second what Dev said. For example, Oracle has a 'Migration Workbench' tool, but it presupposes at least a working knowledge of Oracle. If you have that, it's a helpful...

I went through the same process a while back (coming from Oracle) and the syntax of SQL Server is fairly similar. If you look at Books Online for SQL Server,...