We have exported MS Sql Database Table to database under a web database server from Local MS Sql Server 2000. After Exporting We Checked the indexes of the table but none showed. We are still able to query data. Where did the indexes go, and what should we do in case we need to add or modify an index?
Thread: No Indexes Exported
-
No Profile PictureContributing UserDevshed Newbie (0 - 499 posts)
- Join Date
- Jul 2003
- Posts
- 81
- Rep Power
- 12
No Indexes Exported
Rubal Jain
Webspiders Interweb Pvt. Ltd. & Brainus Networks
http://www.it2ecom.com | http://www.brainus.net
Server Management | Dedicated Servers | Reseller Hosting
Experienced, Qualified Techs | 24/7 Support Centers in India
Helm Premium Partners | Email : sales@brainus.net -
Modding: Oracle MsSQL FirebirdDevshed Supreme Being (6500+ posts)
- Join Date
- Jun 2001
- Location
- Outside US
- Posts
- 8,527
- Rep Power
- 539
How did you export? To .sql file?
-
No Profile PictureContributing UserDevshed Newbie (0 - 499 posts)
- Join Date
- Jul 2003
- Posts
- 81
- Rep Power
- 12
I used .. export import utility.
-
Modding: Oracle MsSQL FirebirdDevshed Supreme Being (6500+ posts)
- Join Date
- Jun 2001
- Location
- Outside US
- Posts
- 8,527
- Rep Power
- 539
I'd rebuild the structure through a .sql file (hand checked!!) and then populate it with that tool.
October 27th, 2003, 08:13 AM
Reply With Quote
October 27th, 2003, 08:16 AM
October 27th, 2003, 08:28 AM
October 27th, 2003, 10:01 AM
