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 |
|
paraklete
Starting Member
2 Posts |
 Posted - 2006-10-30 : 13:51:08
|
| We need to create indexes and primary keys in SQL Server 2000 to match the indexes and primary keys that are currently in the Sybase 8 ASA. Is there an "easy" way to do that or once the table structure is completed, do we have to go in and create them one by one? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-30 : 14:51:22
|
| Try to script the indexes from Sybase machine.Open the script in Query Analyzer and rewrite the syntax to T-SQL.I think that will do.Peter LarssonHelsingborg, Sweden |
 |
|
|
paraklete
Starting Member
2 Posts |
Posted - 2006-10-30 : 15:17:11
|
quote:
Originally posted by Peso
Try to script the indexes from Sybase machine.Open the script in Query Analyzer and rewrite the syntax to T-SQL.I think that will do.Peter LarssonHelsingborg, Sweden
We inherited this, I know little about Sybase and have almost NO in house expertise or support. Question: "script the indexes" - is that a SQL command that creates that SQL from existing tables? |
|
|
|
|
|
|
Migrating Sybase 8 ASA to SQL Server 2000