Exporting SQL Server Data

Hi,
We are migrating our website to a new hosting site. The site has a
CMS written in C# with a SQL Server backend. I need to migrate this
but the new hosting site will not allow me to restore the SQL Server
from backup at the new site and requires that I import CSV files.
How can I export the data to a CSV to import at the new hosting site?
Thank you very much.Hi
How about http://www.sqldts.com/299.aspx or you could use BCP and generate
the commands from sysobjects.
John
"KDawg44" <KDawg44@.gmail.com> wrote in message
news:74fd81da-6361-4544-aece-0330377841ce@.z38g2000hsc.googlegroups.com...
> Hi,
> We are migrating our website to a new hosting site. The site has a
> CMS written in C# with a SQL Server backend. I need to migrate this
> but the new hosting site will not allow me to restore the SQL Server
> from backup at the new site and requires that I import CSV files.
> How can I export the data to a CSV to import at the new hosting site?
> Thank you very much.