Servergrid UserLink

Hi guys,

 I have problem copying database from my develpment machine. I used the link provided by servergrid http://www.servergrid.com/support/article.aspx?id=13975 to copy the database. I did copy tables and views using DTSWizard.exe but doesnt allow to copy stored procedures. I tried generating script but couldnt find a way to run the script on server. Enterprise manager comes with servergrid only allow you to create each seperate procedure by typing the code manually.  Does anyone have any idea how to copy stored procedure and schemma or even hot to copy entire database. Any help appriciated. Support at servergrid only have one reply follow the link http://www.servergrid.com/support/article.aspx?id=13975 and use documentation with sql server. Thanks in advance. any help appriciated

 Sonu

Hi Sonu,

You can also try to use the sql publishing wizard tool available at CodePlex. The tool will generate .sql file with complete database schema and data included.

http://www.codeplex.com/sqlhost/wiki/view.aspx?title=database%20publishing%20wizard

 Regards,

Dimi

hi dimi,

Thanks for your reply. publishing wizard did generate .sq file. but where to run the script in severgrid. Thanks again for your reply.

Sonu

So, Bassically in servergrid no way of copying whole database to server. you can only copy tables and view if you want but cant copy stored procedures and schemma. Its realy shame, realy sounds to me users here manually creating the stored procedure or dont want to sharen how they do. Any one knows or done copying stored procedure to servergrid? Thanks in advance for any help.

Sonu

Hi Sonu,

 You can use the script generated by the db pub wizrd to create a DB.  Steps needed are;

1.  Create your DB user and a physical  DB in the control panel.
2.   Go to https://www.servergrid.com/support/sqltools.aspx and give your DB user DBO access rights.
3.   Use one of the following methods;
        a)  go to https://www.servergrid.com/mssql/app/connect.aspx and login using the DB user or,
        b) downlaod SQL server management studio express from Microsoft and use this to connect to your new database. (I recommend this personally)
(for either of the above methods you will need to know the DB user and password and the phsical sql server you DB is hosted on e.g. mssql#.servergrid.com)
4.  Once in, find your database and right click on it.  From the menu that shows, select one of the script methods.
5.  In the window that opens up, replace the existing script with the DB script you created using the DB publishing tool Dimi mentioned in a previous post.
6.  Run the script.

I do this all the time and it works like a charm so you shouldn't have too many problems.
 

Hope it helps

Terry.
 

Thanks alot Terry,

It works great. Sometimes you looking everywhere but dont try the simplest way.  I tried all the hard ways but not the simplest way trying to connect my management studio but instead keep tring copying my existing data. Thanks for making things easier.

Sonu