Why Can't SSMS Script Data???

Why Can't SSMS Script Data???

Post by Jonathan W » Mon, 07 Dec 2009 12:33:43


I just can't believe this. Please tell me I'm missing something obvious.

I need to copy a local database to a GoDaddy hosting account (yeah, yeah, I
know). GoDaddy only supports restoring BAK files that were generated from
the GoDaddy site, so I can't back it up on my computer and then restore to
the GoDaddy server. It appears the only option I have is to execute SQL
scripts in order to populate the data.

I was able to figure out how to copy all the database objects (schema) by
scripting those objects, but after spending considerable time on this I
still do not see how to script all the data in my tables. I'm using SQL
Server 2005.

I just cannot believe SSMS isn't up to the task!

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.yqcomputer.com/
 
 
 

Why Can't SSMS Script Data???

Post by Plamen Rat » Mon, 07 Dec 2009 14:40:07

SSMS in SQL Server 2008 supports scripting data. For SQL Server 2005 you can use the Database Publishing wizard:
http://www.yqcomputer.com/
http://www.yqcomputer.com/
http://www.yqcomputer.com/ %20Publishing%20Wizard

--
Plamen Ratchev
http://www.yqcomputer.com/

 
 
 

Why Can't SSMS Script Data???

Post by David Port » Tue, 08 Dec 2009 05:08:13


Management Studio 2008 will do it. You can get that with Dev Edition
(typically costs less than $50).

Or use Visual Studio Team System 2005 or 2008 Database Edition.

--
David Portas