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 |
editplus
Starting Member
1 Post |
Posted - 2013-09-12 : 23:40:54
|
I have SQL Server 2008-R2 database installed in local machineHow to import a remote database into it ? |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-09-13 : 00:45:21
|
Do you wish to import or access the remote DB?For accessing in the connection window you should give server name, username and password.....For import simply generate script from remote DB and then run same script in your local DBTo generate DB Script, 1) Right click on remote DB2) select Genearate Script3) follow the wizard and Choose the option for Schema and Data for complete database--Chandu |
|
|
|
|
|