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 |
satheesh
Posting Yak Master
152 Posts |
Posted - 2014-08-18 : 05:29:53
|
Hi All,I have to transfer a huge chunk of data from a table so i created my first SSAS cube. Now i want to transfer this. How to export this cube to transfer via mail. Any help will be highly appreciated.ThanksRegards,SG |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-08-18 : 05:36:05
|
BCP is the fastest way to export and import data for tables.Why did you opt for the CUBE approach? Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
satheesh
Posting Yak Master
152 Posts |
Posted - 2014-08-18 : 06:43:28
|
Thanks for your reply. How to copy just a table using BCP method. Any help will be highly appreciated.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-08-18 : 09:18:32
|
BCP "dbo.Table" out "C:\Temp\data.txt" -SServerNameHere -PPassword -UUserName Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|
|
|