Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AbuAnas
Starting Member
4 Posts |
 Posted - 2004-09-27 : 02:10:04
|
| Hi,At my work we have two instances of the same MSSQL-based software are running on two two different servers. Each instance of the system has undergone some customization in both the data structure and gui. And each one may have some different conveintions (i.e one will start user id's from 1 and the other one will use ActiveDirectory data).My job is two bring both systems togather, consolidate them and make them one system. Since am not experiant MSSQL admin/user (though I have good knowledge of SQL) I don't know where to start? the DB is very huge with 100+ tables and thousands of records. I have a lot of questions. Examples are:Is there any way/tool to list all tabels:fields that refer's to other table? (i.e. an employee table has a dept_no field, hence the employee table will be listed as related to dept table)Is there any way/tool that will change a value of a primary key, and then will lookup all FK's that refere to that PK and change it to the new value? Best regards,AbuAnas |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-27 : 02:16:55
|
| right click on the table and choose all tasks then display dependencies.set up the relationship and check the box with cascade update |
 |
|
|
AbuAnas
Starting Member
4 Posts |
Posted - 2004-09-27 : 03:04:45
|
| Hi,Thank you for the quick answer. I did that but it seems CA* didn't build the relation's on the DB physical level!! means dept_no in the emp table has nothing to do with the dept table!AbuAnas |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-27 : 03:12:46
|
quote:
Originally posted by AbuAnas
Hi,Thank you for the quick answer. I did that but it seems CA* didn't build the relation's on the DB physical level!! means dept_no in the emp table has nothing to do with the dept table!AbuAnas
what exactly do you mean? |
|
|
|
AbuAnas
Starting Member
4 Posts |
Posted - 2004-09-27 : 03:44:18
|
| CA is the company who made the product am working on, namely Unicenter ServerDesk. What I mean is, suppose that simple relation example I mentioned. The employee table has a field called dept_no which logically refers to the Dept_no in the dept table. Though the relation exists logically and we know that the emp.dept_no has values from dept.dept_no, but the relattion is not part of the table defination. |
|
|
|
|
|
|
Consolidation of 2 DB's