I'm able to use SQL 2005's VB management page to import the tables and views from a database in SQL 2000 on another server, but how do I get all of the data like stored procedures, etc...?
you were better off backing up the database from sql 2000 (right click db, all tasks > backup database), then restoring in from device on 2005, that would have kept all your data|||
if you want the entire dbs data you can perform backup and restore in sql 2005........for certain objects you can script them and execute the script in sql 2k5.......
No comments:
Post a Comment