Windows Forum

Ask something
Discussion Locked

SQL fun

0 helpful
4 replies

by nsteere

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Wellll,

I need to know if anyone has successfully copied/migrated/attached/exported (any) a SQL 2000 database to a SQL 7 server. I have done the reverse but no such luck trying the above methods. Anyone who has done this process pahleez give me the goodz.

4 replies

by volkerk

I don't know how complex your DB is and what type of data it contains, but in most cases you should be able to at least migrate the data via bcp.exe, doing an export to file, then an import into the other server again with bcp.exe after manually creating the table structure.

Also, if I recall right, the "Transact-SQL Guru" book has a stored procedure to create table creation scripts from an existing DB, so this step of the process can be automated.

This discussion is closed to new replies.