Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mai
Starting Member
2 Posts |
 Posted - 2009-02-18 : 05:15:26
|
| Hi everyone. Can somebody help me. Just new in SQL. I'm using SQL Server Express 2008. I have already make a tables in my database on my computer (Computer Name: WS3). I just want to copy the one i made to another computer (Computer Name: WS2). What shall i do to transfer the whole database from WS3 to WS2 computer. Without being connected to WS3 or without connecting to a remote PC.. Is that possible. Thanks. Any Little input will help. Thanks In advance. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-02-18 : 05:24:42
|
| Create a backup on the old and restore it on the new computer, If it will fit on a CD or other external media, then no problem, if not, then you will have to find a way to get the backup to the new computer. |
 |
|
|
Mai
Starting Member
2 Posts |
Posted - 2009-02-18 : 21:05:25
|
| I already copy the database to my USB then i already transfer the data on the same path where my Database is (WS3 to WS2). But when i open my SQL i cant find the location of the data i copied. Here's the complete path where i copied the database c:\program files\Microsoft SQL Server\MSSQL10.SQLExpress\MSSQL\Data. So Where will i find that? What seems to be the problem? So when i open my SQL what would be the Server Type? ServerName? and authentication? , that i have to write to connect to my databased so that i can see or i can have an access to my database. Sorry im so confused about it. By the way thanks for the input u gave me. I wish u could still help me in my problem. Thanks! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-19 : 03:16:01
|
| have you installed sql server in ws2? if yes connect to default instance of sql server on the computer and restore db from stored location. |
|
|
|
|
|
|
SQL Database Conversion