upload database

Question

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?

bahare g · Answer

hi my frined. i design database in my computer.my website is dynamic and i write sql commands in stored procedure.when i buy a hosti create a database name and user for my database in my pleskthen 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 databasewhen import processes finished i see all local tables with data there are in my target databasebut my local stored procedure are not copy in my target database.

Kirtan Patel · Answer

Friend  I m still unclear about your problem can you explain it more clearly i can solve your problem :)

Amit Choudhary · Answer

you can also use 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 Kumar · Answer

Hi Generate the Script of your stored procedure and execute that on server. by this way you can get all Sp in server.