Hi,
whats the best way to copy a table from sql server 2005 to 2000?
Thanks for any help...
In SQL Server 2005, the Copy Database Wizard in the SQL Server Management workbench enablesyou to copy database objects, and is specialized for doing this.|||I'm running 205 express edition, i can't seem to find the wizard youare talking about... is it only in te fuill version? Is so, whatoptions do i have?
|||If you have a full copy of SQL Server 2000, open your database then go to the query analyzer open the object browser and right click on the table you want and then click on scripting option to enable filegroup because file group is required in SQL Server 2005 then script it and execute it with the tool you are using to manage it. Hope this helps.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment