converting sql7 database to sql2000greenspun.com : LUSENET : SQL Server Database Administration : One Thread
have two installs one for sql7 another for sql2000 is there a way to convert the database without converting the whole install of sql7
-- Anonymous, March 20, 2002
I would use SQL Server 2000's DTS (this appears as Import and Export Data when you click on Start/Programs/Microsoft SQL Server). This will allow you to copy data and objects from the SQL Server 7 server to the SQL Server 2000 server.
Hope this helps,
-- Anonymous, March 22, 2002