Importing Database

I have SQL Server 7.0 and I am going to update to SQL Server 2000, Can I imp
ort the database? Can I make a backup from SQL Server 7.0 and then to restor
e with SQL Server 2000. (I have tape backup).
Thanks and Best Regards,hi jose,
yes, you can restored backup file of SQL 7 database to SQL Server 2000. SQL
2000 will upgrade
the SQL 7 database during the restore process. Once restore process is over
run update
statistics on all tables, ideally WITH FULLSCAN.
Vishal Parkar
vgparkar@.yahoo.co.in|||Please refer to these links that will provide you all the information that
you would possibly need to perform the upgrade:
How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
http://www.microsoft.com/technet/pr...oy/sqlugrd.mspx
Upgrading from SQL 7 to SQL 2000
http://msdn.microsoft.com/library/d...-us/instsql/in_
upgrade_5jw3.asp
This link will give you all about SQL installation
http://msdn.microsoft.com/library/d...-us/howtosql/ht
_install_5vsj.asp
FAQs to know before you plan the upgrade
http://support.microsoft.com/defaul...kb;en-us;261334
Hope this helps.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.