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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Transfering Tables From one database to another

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.
Go to Top of Page

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
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

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 server

reddy
Go to Top of Page

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 server

reddy


then why use ssis?
isnt it easier to detach from current server and then attach to other one?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

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 server

reddy


then why use ssis?
isnt it easier to detach from current server and then attach to other one?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://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.
Go to Top of Page
   

- Advertisement -