copy database from server

Question

i install new window and i forget take a copy of my database file but i uploaded my database erst.how can i copy my database from server to my computer.with export only copy tables and views ,but i need my stored procedures too. how can i return my database completely?

Kirtan Patel · Accepted Answer

Yes Friend ,
you ca define Username Password etc Like Below set connection Properties . :)
ServerConnection conn = new ServerConnection( "rune\sql2008" );
conn.LoginSecure = false ;
conn.Login = "login";
conn.Password = "vpassword";

bahare g · Answer

that's right.i set user pass and databasename but in transfer.transfer show faild to connect mydatabase error.
user,pass,and database name are right.but i do not why it have problem.
ServerConnection conn = new ServerConnection(new SqlConnection(" Data Source=server name;Initial Catalog=mydatabase name;User ID=myuser;Password=****; "));

bahare g · Answer

frinde tnx so much for your help,but i have a littel problem in this code.
is rune\sql2008 address of local database or uploaded database?what i write instead of rune\sql2008?i use sql2005.
ServerConnection conn = new ServerConnection("rune\sql2008");
and my uploaded database have user and password,then where can i write address,user and password of my uploaded database to transfer information from it?

Kirtan Patel · Answer

Friend,
Which Database you are Using SQL Server or Local Access/SQL Server mdf file ??? database if you are using Database Which is on SQL Server then
here is Code that iis Using
please check " do you like this answer check box " :)
//First Reference the assembly microsoft.sqlserver.smo.dll
//Then Import SMO by Following Line
using Microsoft.SqlServer.Management.Smo
//------------------------------------------------
//Code Like Below then
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: Consolas, "Courier New", Courier, Monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }
ServerConnection conn = new ServerConnection( "rune\sql2008" );
Server server = new Server(conn);
Database newdb = new Database(server, "new database" );
newdb.Create();
Transfer transfer = new Transfer(server.Databases[ "source database" ]);
transfer.CopyAllObjects = true ;
transfer.CopyAllUsers = true ;
transfer.Options.WithDependencies = true ;
transfer.DestinationDatabase = newdb.Name;
transfer.DestinationServer = server.Name;
transfer.DestinationLoginSecure = true ;
transfer.CopySchema = true ;
transfer.CopyData = true ;
transfer.Options.ContinueScriptingOnError = true ;
transfer.TransferData();