hi frindes
when i upload my database on server all tables with data import on server correctly but there is not my stored proced on server.
how can i upload database with all stored procedure correctly?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
bahare gPosted Nov 16, 2009, 1:10 AM
i design database in my computer.my website is dynamic and i write sql commands in stored procedure.when i buy a host,i create a database name and user for my database in my plesk,then i must run sql server and connect it with my user to upload my database.i right click in my database name then import my local database on target database,when import processes finished i see all local tables with data there are in my target database,but my local stored procedure are not copy in my target database.
Kirtan PatelPosted Nov 11, 2009, 7:46 AM
I m still unclear about your problem
can you explain it more clearly i can solve your problem :)
Amit ChoudharyPosted Nov 11, 2009, 7:43 AM
sqlserver Database publishing Tool to publish you database at remote server...
SqlPubWiz.exe is used for publishing database and it can be found
c:\program files\Microsoft Sql Server\90\Tools\Publishing\1.2\
similar kind of path
This only if you are using SQLSERVER2005 .....
Gaurish KumarPosted Nov 11, 2009, 2:09 AM
Generate the Script of your stored procedure and execute that on server.
by this way you can get all Sp in server.