|
Home > Archive > MS SQL Server DTS > January 2006 > Export SQL Server to ACCESS: how to keep relationship and constraints
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Export SQL Server to ACCESS: how to keep relationship and constraints
|
|
| q_test 2006-01-19, 8:24 pm |
| I want to export my existing sql server 2000 database to a new ACCESS
2000 database. I don't want to export any data, but just all the table
structures, and constraints and relationships between tables.
Right now I use the export wizard to export all tables. But I get a copy
of ACCESS with no primary keys and foreign keys.
How do I preserve the relationship between tables during the export?
| |
| Allan Mitchell 2006-01-21, 7:23 am |
| Hello q_test,
Going from SQL Server to Access you can't, well not very easily anyway.
You will have to write something that queries the constraints etc on SQL
Server and then applies that logic in the style of Access to the Access DB.
This will involve coding yourself as there is nothing in the box that will
do this
Allan
> I want to export my existing sql server 2000 database to a new ACCESS
> 2000 database. I don't want to export any data, but just all the table
> structures, and constraints and relationships between tables.
>
> Right now I use the export wizard to export all tables. But I get a
> copy of ACCESS with no primary keys and foreign keys.
>
> How do I preserve the relationship between tables during the export?
>
|
|
|
|
|