[SQL Server 2005]
I just moved to SQL 2005 developer edition & was trying to figure out how to import all objects (all tables, views & stored procedures ... are the main ones I need at the moment) into a DB from SQL 2k ?
There's an option to chose "Write Query to ..." in the Import Wizard, but I'm not good at all at SQL 
or is there an option/tool to help me out w/ this.
Could someone please point me in the right direction if this has been posted before, or if you have a Script that does this, thanks much appreciated.Use the > Tasks > Generate Scripts > method on the database node.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||
You can also use Backup/Resotre method if you want exact replica of the SQL Server 2000 database.... Another option is Copy Database Wizards ...
Madhu
No comments:
Post a Comment