|
Home > Archive > MS SQL Server > October 2006 > Importing data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Harry Strybos 2006-10-24, 6:31 pm |
| Hi Guys
Can someone give me some directions on importing data from another server
e.g.
INSERT INTO SQL2005.MyDB1.dbo.PostCode --this is SQL 2005
( Suburb, PostCode, State)
SELECT Suburb, PostCode, State
FROM SQL2000.MyDB2.dbo.PostCode --this is SQL 2000
Thanks heaps...BooksOnLine not too helpful
| |
| Dan Guzman 2006-10-24, 6:31 pm |
| The easiest way I've seen is to use the Import wizard. In the SQL Server
Management Studio Object Explorer, right-click on the target (or source)
database and select All Tasks-->Import Data (or Import Data).
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Harry Strybos" < harry_NOSPAM@ffapays
mart.com.au> wrote in message
news:3wIRg.14671$b6.160428@nasal.pacific.net.au...
> Hi Guys
>
> Can someone give me some directions on importing data from another server
> e.g.
>
> INSERT INTO SQL2005.MyDB1.dbo.PostCode --this is SQL 2005
> ( Suburb, PostCode, State)
> SELECT Suburb, PostCode, State
> FROM SQL2000.MyDB2.dbo.PostCode --this is SQL 2000
>
> Thanks heaps...BooksOnLine not too helpful
>
| |
| Uri Dimant 2006-10-24, 6:31 pm |
| Harry
Have you created a linked server to SQL Server 2000 ?
"Harry Strybos" < harry_NOSPAM@ffapays
mart.com.au> wrote in message
news:3wIRg.14671$b6.160428@nasal.pacific.net.au...
> Hi Guys
>
> Can someone give me some directions on importing data from another server
> e.g.
>
> INSERT INTO SQL2005.MyDB1.dbo.PostCode --this is SQL 2005
> ( Suburb, PostCode, State)
> SELECT Suburb, PostCode, State
> FROM SQL2000.MyDB2.dbo.PostCode --this is SQL 2000
>
> Thanks heaps...BooksOnLine not too helpful
>
|
|
|
|
|