|
View unanswered posts | View active topics
It is currently Tue May 13, 2025 2:09 am
|
Page 1 of 1
|
[ 3 posts ] |
|
| Author |
Message |
|
rykard
Occasionally has a life
Joined: Sat Nov 28, 2009 5:28 pm
Posts: 228
|
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.
_________________
cheers
Rich
A Vision of a Champion is someone who is bent over, drenched with sweat, at the point of exhaustion, when no one else is watching
|
| Fri Jun 18, 2010 3:35 pm |
|
|
|
big_D
What's a life?
Joined: Thu Apr 23, 2009 8:25 pm
Posts: 10691
Location: Bramsche
|
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.
_________________
"Do you know what this is? Hmm? No, I can see you do not. You have that vacant look in your eyes, which says hold my head to your ear, you will hear the sea!" - Londo Molari
Executive Producer No Agenda Show 246
|
| Fri Jun 18, 2010 5:25 pm |
|
|
|
rykard
Occasionally has a life
Joined: Sat Nov 28, 2009 5:28 pm
Posts: 228
|
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...
_________________
cheers
Rich
A Vision of a Champion is someone who is bent over, drenched with sweat, at the point of exhaustion, when no one else is watching
|
| Fri Jun 18, 2010 9:38 pm |
|
|
|
|
Page 1 of 1
|
[ 3 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 2 guests |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
|
|
