 | |
ODBC Imports of entire Database
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
ODBC Imports of entire Database -
10-10-2006
, 11:13 AM
#2
| |||
| |||
|
|
Thread-Topic: ODBC Imports of entire Database thread-index: AcbshvXCiFpH9R1BRJqN2xT9tTcfTw== X-WBNR-Posting-Host: 66.191.71.66 From: =?Utf-8?B?RG9u?= <djw (AT) nospam (DOT) postalias Subject: ODBC Imports of entire Database Date: Tue, 10 Oct 2006 09:13:01 -0700 Lines: 12 Message-ID: <BAAEC242-980B-4F8B-B093-427D784D10D0 (AT) microsoft (DOT) com 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 |
#3
| |||
| |||
|
|
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 (AT) nospam (DOT) postalias Subject: ODBC Imports of entire Database Date: Tue, 10 Oct 2006 09:13:01 -0700 Lines: 12 Message-ID: <BAAEC242-980B-4F8B-B093-427D784D10D0 (AT) microsoft (DOT) com 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 |
#4
| |||
| |||
|
|
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 (AT) nospam (DOT) postalias Subject: ODBC Imports of entire Database Date: Tue, 10 Oct 2006 09:13:01 -0700 Lines: 12 Message-ID: <BAAEC242-980B-4F8B-B093-427D784D10D0 (AT) microsoft (DOT) com 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 |
#5
| |||
| |||
|
|
Thread-Topic: ODBC Imports of entire Database thread-index: AcbtPPxmdjicoknEQSuo0y0suKO2wg== X-WBNR-Posting-Host: 66.191.71.66 From: =?Utf-8?B?RG9u?= <djw (AT) nospam (DOT) postalias References: <BAAEC242-980B-4F8B-B093-427D784D10D0 (AT) microsoft (DOT) com nOK2XaN7GHA.1860 (AT) TK2MSFTNGXA01 (DOT) phx.gbl 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 (AT) microsoft (DOT) com 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 (AT) nospam (DOT) postalias Subject: ODBC Imports of entire Database Date: Tue, 10 Oct 2006 09:13:01 -0700 Lines: 12 Message-ID: <BAAEC242-980B-4F8B-B093-427D784D10D0 (AT) microsoft (DOT) com 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 |
#6
| |||
| |||
|
|
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 (AT) nospam (DOT) postalias References: <BAAEC242-980B-4F8B-B093-427D784D10D0 (AT) microsoft (DOT) com nOK2XaN7GHA.1860 (AT) TK2MSFTNGXA01 (DOT) phx.gbl 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 (AT) microsoft (DOT) com 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 (AT) nospam (DOT) postalias Subject: ODBC Imports of entire Database Date: Tue, 10 Oct 2006 09:13:01 -0700 Lines: 12 Message-ID: <BAAEC242-980B-4F8B-B093-427D784D10D0 (AT) microsoft (DOT) com 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 |
#7
| |||
| |||
|
|
Thread-Topic: ODBC Imports of entire Database thread-index: AcbuMFf+sDWXV57STEGflwN62c+UrQ== X-WBNR-Posting-Host: 66.191.71.66 From: =?Utf-8?B?RG9u?= <djw (AT) nospam (DOT) postalias References: <BAAEC242-980B-4F8B-B093-427D784D10D0 (AT) microsoft (DOT) com nOK2XaN7GHA.1860 (AT) TK2MSFTNGXA01 (DOT) phx.gbl |
<68D0ged7GHA.3352 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>
Quote:
|
Subject: RE: ODBC Imports of entire Database Date: Thu, 12 Oct 2006 11:58:02 -0700 Lines: 182 Message-ID: <B98E12C2-AAE1-48B6-9B97-8A82F1F9121D (AT) microsoft (DOT) com 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:68420 NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250 X-Tomcat-NG: microsoft.public.sqlserver.dts 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 (AT) nospam (DOT) postalias References: <BAAEC242-980B-4F8B-B093-427D784D10D0 (AT) microsoft (DOT) com nOK2XaN7GHA.1860 (AT) TK2MSFTNGXA01 (DOT) phx.gbl 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 (AT) microsoft (DOT) com 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 (AT) nospam (DOT) postalias Subject: ODBC Imports of entire Database Date: Tue, 10 Oct 2006 09:13:01 -0700 Lines: 12 Message-ID: <BAAEC242-980B-4F8B-B093-427D784D10D0 (AT) microsoft (DOT) com 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.