Click here to Skip to main content
15,895,557 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Select Statement ? Pin
mrfalk16-Oct-13 13:13
mrfalk16-Oct-13 13:13 
GeneralRe: SQL Select Statement ? Pin
Kornfeld Eliyahu Peter16-Oct-13 20:06
professionalKornfeld Eliyahu Peter16-Oct-13 20:06 
GeneralRe: SQL Select Statement ? Pin
Mycroft Holmes16-Oct-13 22:01
professionalMycroft Holmes16-Oct-13 22:01 
GeneralRe: SQL Select Statement ? Pin
PIEBALDconsult18-Oct-13 13:26
mvePIEBALDconsult18-Oct-13 13:26 
AnswerRe: SQL Select Statement ? Pin
Kornfeld Eliyahu Peter16-Oct-13 20:02
professionalKornfeld Eliyahu Peter16-Oct-13 20:02 
QuestionNeed help in this.. Pin
codestar00710-Oct-13 21:46
professionalcodestar00710-Oct-13 21:46 
AnswerRe: Need help in this.. Pin
Eddy Vluggen10-Oct-13 22:33
professionalEddy Vluggen10-Oct-13 22:33 
QuestionCopy over a single table in sql server 2008 Pin
vkEE10-Oct-13 3:00
vkEE10-Oct-13 3:00 
AnswerRe: Copy over a single table in sql server 2008 Pin
Corporal Agarn10-Oct-13 3:13
professionalCorporal Agarn10-Oct-13 3:13 
GeneralRe: Copy over a single table in sql server 2008 Pin
vkEE10-Oct-13 3:19
vkEE10-Oct-13 3:19 
AnswerRe: Copy over a single table in sql server 2008 Pin
Richard MacCutchan10-Oct-13 3:36
mveRichard MacCutchan10-Oct-13 3:36 
GeneralRe: Copy over a single table in sql server 2008 Pin
vkEE10-Oct-13 3:44
vkEE10-Oct-13 3:44 
GeneralRe: Copy over a single table in sql server 2008 Pin
Richard MacCutchan10-Oct-13 4:11
mveRichard MacCutchan10-Oct-13 4:11 
AnswerRe: Copy over a single table in sql server 2008 Pin
Eddy Vluggen10-Oct-13 5:17
professionalEddy Vluggen10-Oct-13 5:17 
GeneralRe: Copy over a single table in sql server 2008 Pin
vkEE10-Oct-13 5:38
vkEE10-Oct-13 5:38 
GeneralRe: Copy over a single table in sql server 2008 Pin
Richard Deeming10-Oct-13 6:21
mveRichard Deeming10-Oct-13 6:21 
How about reversing the process first? On the source server, create a new empty database and use SELECT INTO to copy just the table(s) you want. Back up the (much smaller) database, copy the backup to the destination server, restore, and SELECT INTO the destination table.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: Copy over a single table in sql server 2008 Pin
Eddy Vluggen10-Oct-13 8:41
professionalEddy Vluggen10-Oct-13 8:41 
AnswerRe: Copy over a single table in sql server 2008 Pin
Simon_Whale10-Oct-13 5:45
Simon_Whale10-Oct-13 5:45 
AnswerRe: Copy over a single table in sql server 2008 Pin
RedDk11-Oct-13 10:49
RedDk11-Oct-13 10:49 
AnswerRe: Copy over a single table in sql server 2008 Pin
coded00717-Oct-13 21:39
professionalcoded00717-Oct-13 21:39 
AnswerRe: Copy over a single table in sql server 2008 Pin
rashin ghodratzade18-Oct-13 18:55
rashin ghodratzade18-Oct-13 18:55 
Questioninsert rows into single table from two table which has different columns Pin
abu.bdt8-Oct-13 23:00
abu.bdt8-Oct-13 23:00 
AnswerRe: insert rows into single table from two table which has different columns Pin
Richard MacCutchan8-Oct-13 23:27
mveRichard MacCutchan8-Oct-13 23:27 
AnswerRe: insert rows into single table from two table which has different columns Pin
Simon_Whale9-Oct-13 0:55
Simon_Whale9-Oct-13 0:55 
AnswerRe: insert rows into single table from two table which has different columns Pin
coded00717-Oct-13 21:40
professionalcoded00717-Oct-13 21:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.