May 28, 2002 at 10:05 pm
If we migrate a databases to the a different SQL 7 server, will indices and
default properties come along or will I have to rebuild these? My experience
with using Enterprise Manager to copy a database is that the new database
has lost its indices and defaults. Do you know a way to retain this
information in the transfer?
May 29, 2002 at 4:48 am
With the Import/Export wizard. When you get to "Specify Table Copy or Query" select "Copy objects and data between SQL Server databases", then next screen "Select Objects to Copy" you should be able to next right thru, however if you want to be sure indexes are done then uncheck "Use Default Option" near the bottom and press the options button that enables when you do this. A new dialog "Advanced Copy Options" pops up and Copy indexes should already be checked, if not do so and press OK. Then next thru screen to finish.
If you however are copying the whole database to a new location tht will be exactly the same you caould save some trouble with doing a backup of the database and a restore to the new location.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply