| Author |
Topic |
|
disha
Starting Member
34 Posts |
 Posted - 2008-01-22 : 08:27:09
|
| hi,my client will provide me with sample data . now i have sql server installed on my laptop.how do i convert his data (which i guess will be dump files of sql server ) into my laptop as a database .it will be two tables only .also my client will provide me with oracle data .i want to convert it to sql server as database is it possible .plz help regards,Disha |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-22 : 23:06:37
|
| What kind of file? You can restore it if it's backup file. If oracle data are in text file, you can load them to sql table with bcp. |
 |
|
|
disha
Starting Member
34 Posts |
Posted - 2008-01-23 : 02:44:54
|
| might be excel filesthnxx for ur reply how do i convert it to sql server database plz help. i know about import expor ..plz provide me steps to do that ... am litle careful becoz i havent done this bfore..consider me as a newbie,,while providing the steps..thnxxregards,disha |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-23 : 23:14:09
|
| Search data import/export wizard in books online. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
disha
Starting Member
34 Posts |
Posted - 2008-01-24 : 05:11:04
|
| thnx 4 repy i have excel sheets i need to export them 2 sql server to create a sample database .. dats y i wana know how to export those excel sheets in dts to a create a sample database |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-01-24 : 09:02:33
|
quote:
Originally posted by disha
thnx 4 repy i have excel sheets i need to export them 2 sql server to create a sample database .. dats y i wana know how to export those excel sheets in dts to a create a sample database
Did you mean to create a table or database?MadhivananFailing to plan is Planning to fail |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-25 : 10:00:31
|
| If you have SQL Server installed , you could do an IMPORT from Excel into SQL Server.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
ells
Starting Member
25 Posts |
Posted - 2008-01-30 : 07:07:09
|
| If you have SQL server installed you could create two simple DTS packages. Each one would have a source file item and a sql server connection. Then add a transform data task. Set the source of the transform task to be the file, set the destination and click the create button. This when executed will drag the file contents into a table. This is a very rough and ready way of doing it, but straight forward if you can use DTS. |
|
|
|
|
exporting to sql server on my laptop