RE: ODBC Imports of entire Database

When I run the wizard it does not give me the option to copy the entire
database. It disables that option. What is the best way to list all of the
tables so that I can script an import? I am using the ODBC .Net connector to
connect to the other database.

I can schedule SSIS packages but can't get them to just import the data
without scripting table by table.

Please Help.


"Vincent Xu [MSFT]" wrote:

Hello,

-- Get the list of tables and import all of them creating tables in SQL if
needed.

When you run Import and Export Wizard, it will enable you to import the
entire database from source server. I have tested on my machine. Check the
article:

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

Creating Packages Using the SQL Server Import and Export Wizard
http://msdn2.microsoft.com/en-us/library/ms141209.aspx

-- 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.

When you created a package, you can schedule it to run any time you want.

How to: Run a Package Using a SQL Server Agent Job
http://msdn2.microsoft.com/en-us/library/ms139805.aspx

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: AcbtPPxmdjicoknEQSuo0y0suKO2wg==
X-WBNR-Posting-Host: 66.191.71.66
From: =?Utf-8?B?RG9u?= <djw@xxxxxxxxxxxxxxxx>
References: <BAAEC242-980B-4F8B-B093-427D784D10D0@xxxxxxxxxxxxx>
<nOK2XaN7GHA.1860@xxxxxxxxxxxxxxxxxxxxx>
Subject: RE: ODBC Imports of entire Database
Date: Wed, 11 Oct 2006 06:56:01 -0700
Lines: 88
Message-ID: <D13168BF-FAE6-4067-B2B1-225D7BCB0B81@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:68394
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.dts

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






.

Loading