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 · 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. userpassand 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 helpbut 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 passwordthen where can i write addressuser 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();