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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-31 : 08:14:17
|
| ramesh writes "I have a database in sql server with more than 150 tables. Now, i exported the whole of the database in to MS-Access. But all the constraints or relationships existing between sql tables are lost after export. Now, i want, can we export databse without losing the constraints or relations between tables. Can anybody help me??" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2004-01-02 : 07:25:47
|
| what version of SQL Server do you have ?With version 7 and below you can download an upsize wizard which will turn your relationships into triggers in SQL Server. This process is not altogether straight forward and can lead to problems. Read up on potential problems first.I am not sure with SQL2K and above but would have thought they'd have something a bit more rigid in them by now for doing something like this ?aha........http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=31497====Paul |
 |
|
|
|
|
|
Export from sql server to MS-Access