Move data from 7.0 to 2005

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

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

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

Yes, DTS was totally re-written for 2005 and is now called Integration Servi
ces.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/


<mumbaichef@gmail.com> wrote in message
news:1144421429.245370.280550@i39g2000cwa.googlegroups.com...
> 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: 
>

So, DTS will work even if the database structures are different...?
I though DTS will work only if the structures were same.

Thanks
MumbaiChef

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

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

Yes, but the compatibility level with be at 70 after the attach, so if you w
ant 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... 
>
>