November 29, 2011 at 12:19 am
Hi,
i have a table having alot of data on my local machine.i want to import this table to my server.i am using sqlserver2005.i do not have export option.is there any way through code etc?
November 29, 2011 at 1:06 am
This is not a correct way but you can do at server at rest time.
Take the select * from table output in excel.
open the database choose the table Right Click the table.
Give open table there you can able copy data from excel to your table.
November 29, 2011 at 4:39 am
You could create a linked server on production to your local machine. Then you can use SELECT INTO syntax to recreate the table.
Are you using SQL Server Management STudio? Because you should be able to right click on a database and see the Tasks menu there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 29, 2011 at 4:42 am
yes i am using sql management studio and do not have tasks option
November 29, 2011 at 4:46 am
Are you looking in the right place? Check attached screen shot to confirm.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 29, 2011 at 4:52 am
YOu right clicked on database ....i just want to export one table and then import that table in another db....i can view like ur attached
November 29, 2011 at 4:55 am
engrshafiq4 (11/29/2011)
YOu right clicked on database ....i just want to export one table and then import that table in another db....i can view like ur attached
Yes I did. And which is what you were asked to do. From Grant Fritchley's post:
Because you should be able to right click on a database ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 29, 2011 at 4:59 am
engrshafiq4 (11/29/2011)
YOu right clicked on database ....i just want to export one table and then import that table in another db....i can view like ur attached
Exactly.
Right click on the database where you want to import the data. Then select "Tasks." Then select "Import Data..." This will open the Import wizard. Just start following the prompts from there. You'll be able to connect to your local machine (or wherever) that has the data and pick and choose which table or tables you want to move. It's pretty easy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply