transfer a table and data

Question

Post reply

transfer a table and data

pallavi.unde

SSCommitted

Points: 1987
More actions
December 22, 2011 at 3:12 am

#252392

Hello,
How to transfer a table and data from one host to other host??? by query.. without taking backup
Thanks & Regards,
Pallavi

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

Devendrakumar

SSC-Forever

Points: 42493

December 22, 2011 at 3:16 am

#1424658

Fine NO backups. What about Export and Import, SSIS?

pallavi.unde SSCommitted Points: 1987 More actions · Answer 2

But M trying to export and import it's not taking data.... where could i find the setting for data exporting????

Thanks & Regards,
Pallavi

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

pallavi.unde (12/22/2011)
But M trying to export and import it's not taking data.... where could i find the setting for data exporting????

Please explain a bit more what you are trying to do and especially which tool you are using.

If you get any error message, please post them too.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

pallavi.unde (12/22/2011)
But M trying to export and import it's not taking data.... where could i find the setting for data exporting????

Did you select the table you wanted to export? Does it have any data? Are you pulling right table (verify schema name)?

pallavi.unde SSCommitted Points: 1987 More actions · Answer 5

I imported one table on other server it done successfully.

but now if i tried to import whole database on other server it's showing error :-

Messages

Error 0xc0202009: Source 322 - Univ_streamRelation [357]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.

(SQL Server Import and Export Wizard)

Error 0xc02020e8: Source 322 - Univ_streamRelation [357]: Opening a rowset for "[dbo].[Univ_streamRelation]" failed. Check that the object exists in the database.

(SQL Server Import and Export Wizard)

Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)

:crazy:

Thanks & Regards,
Pallavi

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 6

but now if i tried to import whole database on other server it's showing error :-

Why didn't you tell me initially you want to copy full database? 😛

Try this... http://msdn.microsoft.com/en-us/library/ms188664.aspx

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

pallavi.unde (12/22/2011)
I imported one table on other server it done successfully.
but now if i tried to import whole database on other server it's showing error :-
Messages
Error 0xc0202009: Source 322 - Univ_streamRelation [357]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.
(SQL Server Import and Export Wizard)
Error 0xc02020e8: Source 322 - Univ_streamRelation [357]: Opening a rowset for "[dbo].[Univ_streamRelation]" failed. Check that the object exists in the database.
(SQL Server Import and Export Wizard)
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
:crazy:

Ah, so you are using SSIS and the Import/Export wizard. Good to know.

Does the dbo.Univ_streamRelation table exists in the source database? Are you connecting using windows authentication or sql server authentication?

The Import/Export wizard allows you to save the SSIS package. Do that, it will be easier to troubleshoot when you look at the SSIS package directly.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

pallavi.unde SSCommitted Points: 1987 More actions · Answer 8

Univ_streamRelation is not exist in source ..

I am connecting both server database via SQL Authentication

Thanks & Regards,
Pallavi

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 9

1. Connect to SQL Server Database Engine using Object Explorer in SQL Server Management Studio.

2. Expand Databases, right-click a database, point to Tasks, and then click Copy Database.

3. Complete the steps in the wizard.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 10

pallavi.unde (12/22/2011)
Univ_streamRelation is not exist in source ..
I am connecting both server database via SQL Authentication

If the table doesn't exist in the source, why is there a source component trying to open that table?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP