anoopsoni27

 but after uploding this script i didnt get any value  in server(got all value in local server).. i got only create table script.. in internet server

Hi,

Do you means you want to generate script include data? If so, you could use Database Publishing Wizard to generate script with data from database. You could follow below article to use it.

Please see: http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/

http://sqlserverpedia.com/blog/sql-server-bloggers/generate-script-for-objects-along-with-data-using-microsoft-sql-server-database-publishing-wizard/

Thanks.