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 |
|
reddy444
Starting Member
5 Posts |
 Posted - 2013-11-27 : 08:26:29
|
| Hi i am trying to transfer the tables from one database to another data base and for this one i need a 2nd server, can any one help me how to create 2nd server or 2nd instance??reddy |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-11-27 : 10:22:26
|
quote:
Originally posted by reddy444
Hi i am trying to transfer the tables from one database to another data base and for this one i need a 2nd server, can any one help me how to create 2nd server or 2nd instance??reddy
You can create more than one database on a server. So unless you have other reasons for hosting the transferred tables on another server or instance, there is no need for another server/instance.If you do want another server or another instance, you will need to install SQL Sever just like you installed the existing server. If you are installing a second instance, it will have to be a "named instance". SQL Server installation wizard will give you the opportunity to assign a name to the instance when you install. |
 |
|
|
reddy444
Starting Member
5 Posts |
Posted - 2013-11-27 : 10:38:38
|
| Thanks for the post James!I wanted to transfer a database from a server to another server through SSIS. But I have got only 1 server configured on my machine. Could you please help me set up another server and try transferring the db?reddy |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-27 : 11:29:26
|
quote:
Originally posted by reddy444
Thanks for the post James!I wanted to transfer a database from a server to another server through SSIS. But I have got only 1 server configured on my machine. Could you please help me set up another server and try transferring the db?reddy
is the other server also in same domain?do you want to create copy of db or do you want to move db as is to other server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
reddy444
Starting Member
5 Posts |
Posted - 2013-11-27 : 11:40:03
|
| yes i wanted to transfer the database from one server as is to other serverreddy |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-27 : 13:00:47
|
quote:
Originally posted by reddy444
yes i wanted to transfer the database from one server as is to other serverreddy
then why use ssis?isnt it easier to detach from current server and then attach to other one?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-12-03 : 13:13:29
|
quote:
Originally posted by visakh16
quote:
Originally posted by reddy444
yes i wanted to transfer the database from one server as is to other serverreddy
then why use ssis?isnt it easier to detach from current server and then attach to other one?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Even better - use backup/restore to restore a copy to the new instance.It sounds like you need to create a new instance. To do that - run the installation again and create a new named instance. |
|
|
|
|
|
|
Transfering Tables From one database to another