SharePoint 2007: Possible to copy a list instance from 1 server to another without using a feature?

Question

I am not server admin on one of our production systems, neither do I have SQL permissions because of this I need to ask someone to install a WSP package, its annoying.

Is there a way I can copy a list instance from one server to another by just using the SharePoint GUI, I am root admin on 1 machine (dev) and site admin on another (test/production)

I guess in the way that an information worker would do it, not a developer.

Thanks

Answer 1

On top of my head there 2 methods to move/copy a list

---

By using a list template -> Save the list as a list template and then create a copy of the list by using that template

• Must have < 10 MB of list data
• User must have Manage Lists Right site on both source and destination site
• The source site and the destination site must be based on the same site template.

---

By exporting a list to a spreadsheet -> Export data to excel and the import to destination site.

• Useful when list has > 10 MB of list data
• Source and destination site can have different site templates
• User must have Manage Lists Right site on the destination site
• Works for moving a list between sites in the same site collection or in different site collections
• All copied lists will be custom lists in the destination Web site

Microsoft office online has more details on how to copying or moving SharePoint lists