Solved

Any way to have the relationships automatically careated in sql 2005?

Posted on 2011-03-10
2
192 Views
Last Modified: 2012-05-11
Hi, I converted a mysql database into sql 2005 starndard db.  However, no relationships were converted or came with it.  is there a way for automatically creating the relationships for this database based on the same column name that match a primary key in another table?  Thanks.
0
Comment
Question by:lapucca
2 Comments
 
LVL 28

Accepted Solution

by:
sammySeltzer earned 500 total points
ID: 35102057
no way in sql server.

If you have Erwin data modeler, then you can reverse engineer it.
0
 

Author Closing Comment

by:lapucca
ID: 35102175
Thank you.  It's good to know.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question