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 - 2002-01-01 : 23:30:09
|
| Fadi writes "I have a database in Access 97 and I would like to trasform all the data and the tables to SQL Server 2000. I would like also to set new primary keys for each table and provide some constraints. Please let me know how I could do that" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-01 : 23:45:06
|
| You can use DTS(Data Transformation Services wizard ) and import the Access 97 Database. For providing New Primary keys and constraints either you can use Enterprise Manager of Sql Server and do that in design mode or better use Alter statment. Check for "Alter Table" in BOL. it will give you the Syntax with good examples on how to use it, i would suggest you to use Alter Table statement.HTH |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-01-03 : 13:46:05
|
| If you want to retain any or most of your current keys, indexes, and relationships, you should use the Access add-in for Upsizing to SQL Server. DTS will not preserve this information (at least it didn't in version 7.0).--------------------------------------------------------------1000 Posts, Here I come! I wonder what my new title will be... |
|
|
|
|
|
|
trasform from access to Sql Server