July 10, 2008 at 6:12 am
Hi all,
I want to import database table in Sql server 2005.
how can I import data in tables with my schema not dbo.
thanks
July 10, 2008 at 6:54 am
What are you importing from? A flat file, a table from another database? From another server? Need more detail to truly be of help.
-- You can't be late until you show up.
July 11, 2008 at 7:24 am
using dts u can import / export the tables...
October 19, 2011 at 1:14 am
Agreed with tosscrosby
Kindly provide the Source details...
regards
Palash Gorai
October 20, 2011 at 2:55 am
open the sql server's ssms and connect to the server, right click on the database which u want to take backup, then go to task and select backup option, select the database and backup type as full.select the destination drive to store the backup...in options below to the general. select options in that overwrite media. select first two and comeback to general and click on ok then a message will come ur backup is done successfully............................ hope it will help full to u..............:-)
October 23, 2011 at 10:50 pm
You can use Import/Export wizard where you need to specify the Source/Destination.Its quite simple to use it.
It can also be transferred using SSIS Package where you need to specify to Source/Destination.
November 10, 2011 at 6:49 am
yes..simple way to tranfer the table using import/export wizards
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply