Transferring datas from one database to other

• raja_saminathan

  SSCommitted

  Points: 1607

  More actions

  April 2, 2008 at 1:28 am

  #74867

  Hi,

  Can Any body help me by providing ideas in the following:

  I want to transfer the datas in the table from one database to other newly updated database which contains same tables with no datas and some new tables also added in the updated database.

  I need to transfer the data from the old database to new one .

  Expecting your valuable support and kind co-operation

  Thanks

  rajesh

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  April 2, 2008 at 2:13 am

  #797046

  raja_saminathan (4/2/2008)

  ---

  Hi,

  Can Any body help me by providing ideas in the following:

  I want to transfer the datas in the table from one database to other newly updated database which contains same tables with no datas and some new tables also added in the updated database.

  I need to transfer the data from the old database to new one .

  Expecting your valuable support and kind co-operation

  Thanks

  rajesh

  There are many ways of doing this. You could use DTS (or SSIS), bulk export (bcp), or third party tools that have a nice UI and give you plenty of options. Which one you should choose depends on the amount of data you want to migrate, on how familiar you are with either DTS, SSIS, bcp, ...

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software

• Girish Bhat

  Ten Centuries

  Points: 1323

  More actions

  April 2, 2008 at 3:02 am

  #797054

  I believe this is for SQL Server 7.0/2000 as it is under this forum. You can use DTS Import/Export Wizard or build a DTS package to transfer the data. Alternatively, you can use simple INSERT INTO queries while referring to the target table as DatabaseName.OwnerName.Table. IF its on another server you can create a Linked Server to the target server and then use Insert queries while referring to the target table as ServerName.DatabaseName.OwnerName.TableName.

• raja_saminathan

  SSCommitted

  Points: 1607

  More actions

  April 3, 2008 at 3:05 am

  #797682

  Hi Girish,

  Thanks for your Kind Information.

  Well i tried to use the simple Insert into Query ,but i didn't get the things .

  For Eg:

  I have two tables with same name d1 and same no.of columns in two different databases.

  DataBase S1 has values and i want to transfer datas from d1 table in s1 database to d1 table in s2 database.

  I tried like this

  Insert into s2.d1

  values (s1.d1)

  i think ,I didn't get your idea properly,Kindly help me

  Thanks

  Rajesh

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  April 3, 2008 at 5:04 am

  #797714

  raja_saminathan (4/3/2008)

  ---

  Hi Girish,

  Thanks for your Kind Information.

  Well i tried to use the simple Insert into Query ,but i didn't get the things .

  For Eg:

  I have two tables with same name d1 and same no.of columns in two different databases.

  DataBase S1 has values and i want to transfer datas from d1 table in s1 database to d1 table in s2 database.

  I tried like this

  Insert into s2.d1

  values (s1.d1)

  i think ,I didn't get your idea properly,Kindly help me

  Thanks

  Rajesh

  use

  insert into s2.dbo.d1 select * from s1.dbo.d1

  assuming the databases are on the same instance, the source database is s1, the target is s2, and the tables are owned by dbo .

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software

• balamurugan.ganesan

  SSC-Addicted

  Points: 455

  More actions

  April 3, 2008 at 5:06 am

  #797715

  Hi Raja,

  u could use

  insert into s1.d1

  select * from s2.d2

• mvkrishnas-703241

  Newbie

  Points: 3

  More actions

  April 7, 2008 at 9:37 pm

  #799528

  use this query to insert tablestrecture and data in another database

  select * into newtablename from old-databasename.dbo.existingtable-name

  example

  old database is====employee and table name is -- employeedetails

  new database is===emp and table name is -- empdetails

  in query analyzer

  use emp

  select * into empdetails from employee.dbo.employeedetails

• raja_saminathan

  SSCommitted

  Points: 1607

  More actions

  April 9, 2008 at 5:58 am

  #800282

  Thanks Krishna,

  Your Idea Worked fine.

  I have transferred the values from one to other database

  Best Regards,

  Rajesh