RE: ODBC Imports of entire Database

Using SSIS it does not give me the option of importing the entire database.
It gives me a chance to script only and I do not know just how to get the
entire database listed and create the appropriate tables based on the input.
Hopefully I am more clear this time.
What I need to do using SSIS is:
Get the list of tables and import all of them creating tables in SQL if
needed.
I also need to be able to update the tables daily preferrably using an SSIS
package so that we can maintain the SQL base and not have to recreate it at
each use.

"Vincent Xu [MSFT]" wrote:

Hi ,

My understanding of your issue is: You want to use dts to copy data from
another SQL database to current Sql 2005.

As you know, in SQL 2005, we have SSIS. You can use Import and Export
Wizard to achieve your purpose.

How to: Start the SQL Server Import and Export Wizard
http://msdn2.microsoft.com/en-us/library/ms140052.aspx

Hope this helps.


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
Thread-Topic: ODBC Imports of entire Database
thread-index: AcbshvXCiFpH9R1BRJqN2xT9tTcfTw==
X-WBNR-Posting-Host: 66.191.71.66
From: =?Utf-8?B?RG9u?= <djw@xxxxxxxxxxxxxxxx>
Subject: ODBC Imports of entire Database
Date: Tue, 10 Oct 2006 09:13:01 -0700
Lines: 12
Message-ID: <BAAEC242-980B-4F8B-B093-427D784D10D0@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.sqlserver.dts
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:68380
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.dts

I would like to find a way of automating a Database copy and update from
an
existing server. I am only able to connect via ODBC to old server to
read
and cannot modify anything on the old server.
Is there a way with SSIS to copy that database?
I have as yet been unable to use SQL Management to view a list of tables
even, but with MS Query (in office) I have been able to list all of the
tables. I would like to pull all of this data into SQL2005 in order to
do
some analysis on it but just don't seem to see any answer other than
setting
up a package for each and every table. Any help would be GREATLY
appreciated
as I am still new to the SQL Admin world.

Don



.

Relevant Pages

  • Re: SSIS Advice
    ... I have seen your blog and will refer to it in future as I try to get my head around SSIS. ... using my local copy has SQL Server Agent which allows me to set a master and target database. ... Can I ask is this designed to allow control from a local to a server database to run task without the need to have Server Agent on the server? ...
    (microsoft.public.sqlserver.dts)
  • RE: ODBC Imports of entire Database
    ... I am using SSIS but it does not allow me to choose by tables. ... option I can bring up is to create a query to bring in the information. ... another SQL database to current Sql 2005. ... ODBC Imports of entire Database ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase Source. What "data flow source" to use?
    ... when I right-click over a SQL 2005 ... database and select Import Data, the list of providers does not include ... either A) the list of datasources defined in ODBC Datasources on my computer, ... I've been so excited about SSIS and telling my co-workers how ...
    (microsoft.public.sqlserver.dts)
  • RE: ODBC Imports of entire Database
    ... When I run the wizard it does not give me the option to copy the entire ... connect to the other database. ... Start the SQL Server Import and Export Wizard ... SSIS package so that we can maintain the SQL base and not have to recreate ...
    (microsoft.public.sqlserver.dts)
  • Re: Need a tool or program to transfer a database from 2005 to 200
    ... Also my purpose for this post was to find an alternative to SSIS which I ... BACKUP DATABASE/RESTORE DATABASE command 'transfers' the entire database ... Visit www.red-gate.com to look at SQL Compare product ... least a list of tables) from sql server 2005 to 2000? ...
    (microsoft.public.sqlserver.programming)
Loading