I have a SQLServer database, Can I take a copy of this database with all tables and stored procedures and all data in tables ?
and if I can create this copy, how to add it to SQL Server in the new PC ?
I have a mdf database in my computer. And I have sql management studio 2005 installed. I would like to mange the mdf database with this program and I do not know how.
View 3 Repliesi have database in internet ,its now on my server by using ip and username and password but this database is empty table ;i have database on my pc how can i copy all table from this database to new dabase with relation and procedure..?
View 3 RepliesI want to copy a database on a development server to my local server. I am not the server administrator but I have rights to the database. Soon after the wizard Executes the SQL Server Agent Job it fails and the error message says:
The job failed. Check the event log on the destination server for details.
Where do I find this log? Also what could be the problem?
how to copy data from one SQL Server database to other SQL server database using two connection string...
View 4 RepliesI am developing applications that use Microsoft sql server databases. I use SQL Server Management Studio to create these databases and add table, etc. I would like to be able to make a duplicate copy of one of these databases so that I could use one database for production and the other database for testing. Also is there some way that I can copy a table in one database to another database?
View 2 RepliesI am using VWD 2010 with SqlServer 2008. I would like to make an exact copy of my database for testing purposes only so I can test my site before I publish it, make sure everything works so I do not have to reset any tables in my main db.
View 1 RepliesI am getting my database copies as sql script every week. I want the copies as it is on the server.
but there are a lot of option on the scripting. which ones do I need to choose for a proper copy.
i want to copy the structure (with the documents) from our vss server to an webserver. Therefore i want to create an application which is on this webserver. i want to use asp.net.
i don't know what exactly i need therefore :> I have to build somekind of connection? then go throw the structure and copy it somehow :> ?
important: i want to copy the documents with the right creation date ( it changes when i just copy the doc.)
are there APIs for asp.net <-> vss?
I have created a script with pulish to provider button on VS 2010 and I need to deploy my database to my sql server.How can I do that ?
I cannot create a copy of my database on sql server with sql script file.
I have a Table in SQL Server DataBase with 200 + Rows
OriginDest(OID, DID)
I want to Copy all the row from OriginDest Table, DataBase1. To OrginDest, DataBase2 with Same Name
I am in a situation where, I have to copy a databse with records and also want to include new columns in it?
Or can I copy a db schema and later on include new cloumns and then copy a records from old database?
I am using SQL Server 2008 Enterprise Edition R2.
How to copy table from one database to another Database
View 2 RepliesI am stuck with an issue. I have around 200 rows in a table with a particular database. I want to copy those values to another table in a different database.
View 3 RepliesServerName.Database.dbo.TableIn above convention can we use IP address instead of ServerName?
View 1 Repliescopying some data from an existing remote database(SQL2005) to an existing local database.First - I have very little experience in this area. I'm using Visual Web Developer 2008 (VB). Currently if I want to update some data in the local database I do something like this:
Dim conn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("CCCdbConnectionString").ConnectionString)
Dim cmd As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("UPDATE [Orders] Set [OrderStatus]
[code]...
is there a microsoft tool to export the whole database with all of its content to a ".sql" file?i need to use this to copy my database from one database to another.i remember that microsoft make a tool to integrate with sql server 2005.
View 5 RepliesI am running a website from IIS on one computer and I want to view the web page on another computer. the only way I can do this is by using the ipaddress of the computer with IIS on it but would rather have a url. How can I generate a url or use a domain name from [URL]. I signed up for an account on that website but dont know how to use it. I dont know how to configure it.
View 2 Replieswhat is wrong with this line of code?
uploadFile.PostedFile.SaveAs("\ddg3584GraphicsWater lilies.jpg")
how to deploy ASP.net Website having SQL Server on IIS server on Different Computer..
View 2 RepliesI need a program with asp.ne that would connect to the computer user (client) and hardware information Show to me then save to db.
View 1 Repliesi have a asp.net web with vb code and sql database. i am willing to store the details of the users as ip,computer name and time of using the web is it possible.
View 1 RepliesIs there any way to write the client IP and computer name on my server running ASP.NET?
View 4 RepliesI have a file on the server that users will have the possibility to download to thieir computer. For example the filepath could look like below. How would it be possible to save this to the desktop or C: etc.. ?
[Code]....
I'm developing a web application in asp.net using C# and need to access the command prompt of the server computer.
After accessing it I need to run a "ABC.bat" file in the server computer which is in folder "E:Test".
The absolute path of the server is "\MyServer"
PS: I need to run the ABC.bat file on the server machine as the bat file runs couple of more applications which are licensed to that server machine.