SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Transfering Tables From one database to another
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

reddy444
Starting Member

5 Posts

Posted - 11/27/2013 :  08:26:29  Show Profile  Reply with Quote

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
Flowing Fount of Yak Knowledge

3758 Posts

Posted - 11/27/2013 :  10:22:26  Show Profile  Reply with Quote
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 - 11/27/2013 :  10:38:38  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 11/27/2013 :  11:29:26  Show Profile  Reply with Quote
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 - 11/27/2013 :  11:40:03  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 11/27/2013 :  13:00:47  Show Profile  Reply with Quote
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

USA
808 Posts

Posted - 12/03/2013 :  13:13:29  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000