| x404.co.uk http://x404.co.uk/forum/ |
|
| SQL Help needed http://x404.co.uk/forum/viewtopic.php?f=4&t=8957 |
Page 1 of 1 |
| Author: | rykard [ Fri Jun 18, 2010 3:35 pm ] |
| Post subject: | SQL Help needed |
HI, I have to convert some data in a SQL 2005 database. This involves millions of records. Is there a simple way to generate a script to drop all the indexes and one to recreate them again? All help is appreciated. |
|
| Author: | big_D [ Fri Jun 18, 2010 5:25 pm ] |
| Post subject: | Re: SQL Help needed |
When you export the data, it should automatically generate a script, with the data, to generate the tables, indexes etc. and load the data... What exactly are you trying to do? A little more detail would be helpful. |
|
| Author: | rykard [ Fri Jun 18, 2010 9:38 pm ] |
| Post subject: | Re: SQL Help needed |
I am changing the data in approx 400 tables to split the data set, all of the data changes will be in indexes. Was thinking of dropping all the indexex on the DB, doing the data change and then rebuilding the indexes... |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|