| Author |
Move data from 7.0 to 2005
|
|
| mumbaichef@gmail.com 2006-04-07, 9:23 am |
| Hi,
I wanted to know if there is a fast and easier way to move data from
SQL 7.0 to SQL 2005. The database structures are TOTALLY different. The
tables, fields, datatype nothing is same. One table in the new db will
need to collect data from multiple tables in the 7.0 (live) db.
Is there a simple and faster way than importing the data first to Excel
and than manipulating the data and than importing it in 2005?
Thanks in advance!
MumbaiChef
| |
| David Portas 2006-04-07, 11:23 am |
| mumbaichef@gmail.com wrote:
>
> Is there a simple and faster way than importing the data first to Excel
> and than manipulating the data and than importing it in 2005?
>
Practically anything ought to be simpler and faster than that method!
Have you tried using Integration Services? Even simpler, you could
create a linked server to the 7.0 database and move the data over using
INSERT statements.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
| |
| mumbaichef@gmail.com 2006-04-07, 11:23 am |
| Sorry to ask this question but I am new to this DBA role. What
Integration Services? Do you mean DTS?
Thanks
MumbaiChef
David Portas wrote:
> mumbaichef@gmail.com wrote:
>
> Practically anything ought to be simpler and faster than that method!
> Have you tried using Integration Services? Even simpler, you could
> create a linked server to the 7.0 database and move the data over using
> INSERT statements.
>
> --
> David Portas, SQL Server MVP
>
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
>
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
| |
|
|
| mumbaichef@gmail.com 2006-04-07, 11:23 am |
| So, DTS will work even if the database structures are different...?
I though DTS will work only if the structures were same.
Thanks
MumbaiChef
| |
| David Portas 2006-04-07, 1:23 pm |
| mumbaichef@gmail.com wrote:
> So, DTS will work even if the database structures are different...?
> I though DTS will work only if the structures were same.
>
The Import/Export Wizard expects the source and target data structures
to be similar but the Import/Export Wizard is only one tiny feature of
DTS (now Integration Services). You could do it with IS but my other
suggestion is probably a better one. Either restore the old database
onto the new server or create a linked server and then just use INSERTs
to copy the data over.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
| |
| Jan Van der Eecken 2006-04-07, 8:23 pm |
| As a matter of interest, can one just attach a v7.0 database to SQL 2K5?
"David Portas" < REMOVE_BEFORE_REPLYI
NG_dportas@acm.org> wrote in message
news:1144428349.917633.214230@t31g2000cwb.googlegroups.com...
> mumbaichef@gmail.com wrote:
>
> The Import/Export Wizard expects the source and target data structures
> to be similar but the Import/Export Wizard is only one tiny feature of
> DTS (now Integration Services). You could do it with IS but my other
> suggestion is probably a better one. Either restore the old database
> onto the new server or create a linked server and then just use INSERTs
> to copy the data over.
>
> --
> David Portas, SQL Server MVP
>
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
>
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>
| |
| Tibor Karaszi 2006-04-08, 3:23 am |
| Yes, but the compatibility level with be at 70 after the attach, so if you want it in 90, you need
to raise it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Jan Van der Eecken" <jvandereecken@omam.com> wrote in message
news:eCxtwXoWGHA.3492@TK2MSFTNGP05.phx.gbl...
> As a matter of interest, can one just attach a v7.0 database to SQL 2K5?
>
>
> "David Portas" < REMOVE_BEFORE_REPLYI
NG_dportas@acm.org> wrote in message
> news:1144428349.917633.214230@t31g2000cwb.googlegroups.com...
>
>
|
|
|
|