Importing SQL2005 data into SQL2000

We have a SQL 2005 server. After a few months in production, we have
realized that our application which uses sql has a know bug in regards with
sql 2005 and we need to run sql 2000 instead until the bug is resolved. How
can we move our existing data from sql 2005 to sql2000.
Thanks.
news.microsoft.com wrote:
> We have a SQL 2005 server. After a few months in production, we have
> realized that our application which uses sql has a know bug in regards with
> sql 2005 and we need to run sql 2000 instead until the bug is resolved. How
> can we move our existing data from sql 2005 to sql2000.
> Thanks.
BCP, Integration Services or a Linked Server are three possibilities.
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
|||If there is no SQL 2005 specific changes on the table definitions and the
code (stored procedures/functions, or XML data types), you may have to script
all the objects (tables, views, stores procedures, etc.) and execute them in
SQL Server 2000. Then copy the data using SSIS or using BCP depending on how
big is the data to move.
Even is everything goes great, test it, test it again and then test more
before considering it your new production environment.
"news.microsoft.com" wrote:

> We have a SQL 2005 server. After a few months in production, we have
> realized that our application which uses sql has a know bug in regards with
> sql 2005 and we need to run sql 2000 instead until the bug is resolved. How
> can we move our existing data from sql 2005 to sql2000.
> Thanks.
>
>

Importing SQL2005 data into SQL2000

We have a SQL 2005 server. After a few months in production, we have
realized that our application which uses sql has a know bug in regards with
sql 2005 and we need to run sql 2000 instead until the bug is resolved. How
can we move our existing data from sql 2005 to sql2000.
Thanks.news.microsoft.com wrote:
> We have a SQL 2005 server. After a few months in production, we have
> realized that our application which uses sql has a know bug in regards with
> sql 2005 and we need to run sql 2000 instead until the bug is resolved. How
> can we move our existing data from sql 2005 to sql2000.
> Thanks.
BCP, Integration Services or a Linked Server are three possibilities.
--
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
--|||If there is no SQL 2005 specific changes on the table definitions and the
code (stored procedures/functions, or XML data types), you may have to script
all the objects (tables, views, stores procedures, etc.) and execute them in
SQL Server 2000. Then copy the data using SSIS or using BCP depending on how
big is the data to move.
Even is everything goes great, test it, test it again and then test more
before considering it your new production environment.
"news.microsoft.com" wrote:
> We have a SQL 2005 server. After a few months in production, we have
> realized that our application which uses sql has a know bug in regards with
> sql 2005 and we need to run sql 2000 instead until the bug is resolved. How
> can we move our existing data from sql 2005 to sql2000.
> Thanks.
>
>sql

Importing SQL2005 data into SQL2000

We have a SQL 2005 server. After a few months in production, we have
realized that our application which uses sql has a know bug in regards with
sql 2005 and we need to run sql 2000 instead until the bug is resolved. How
can we move our existing data from sql 2005 to sql2000.
Thanks.news.microsoft.com wrote:
> We have a SQL 2005 server. After a few months in production, we have
> realized that our application which uses sql has a know bug in regards wit
h
> sql 2005 and we need to run sql 2000 instead until the bug is resolved. H
ow
> can we move our existing data from sql 2005 to sql2000.
> Thanks.
BCP, Integration Services or a Linked Server are three possibilities.
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
--|||If there is no SQL 2005 specific changes on the table definitions and the
code (stored procedures/functions, or XML data types), you may have to scrip
t
all the objects (tables, views, stores procedures, etc.) and execute them in
SQL Server 2000. Then copy the data using SSIS or using BCP depending on how
big is the data to move.
Even is everything goes great, test it, test it again and then test more
before considering it your new production environment.
"news.microsoft.com" wrote:

> We have a SQL 2005 server. After a few months in production, we have
> realized that our application which uses sql has a know bug in regards wit
h
> sql 2005 and we need to run sql 2000 instead until the bug is resolved. H
ow
> can we move our existing data from sql 2005 to sql2000.
> Thanks.
>
>

IMporting sql2000 backup database ?

Dear all,
I have an database backup from SQL server2000.
How can I import it inside SQL server 2005 ?
regards
sergeserge calderara wrote:
> Dear all,
> I have an database backup from SQL server2000.
> How can I import it inside SQL server 2005 ?
> regards
> serge
Use the RESTORE DATABASE command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||here is how I am proceedig.
First I have creat a new database named NOMOS, same as my old backup. Only
system tables are created here as I want to restore the whol configuration
from my backup.
Then I select the Restore backup from management studio and select my new
created database NOMOS as the destination and my backup file as a source
Then I get error message :
"The backup sets hold a backup of a database other than the existing 'NOMOS'
database"
Which is not treu casue I just made the backup of that databased before
installing 2005 '
thnaks for comments
regards
serge
"Tracy McKibben" wrote:
> serge calderara wrote:
> > Dear all,
> >
> > I have an database backup from SQL server2000.
> > How can I import it inside SQL server 2005 ?
> >
> > regards
> > serge
> Use the RESTORE DATABASE command...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Sorry I find it out...
I forgot to set the overwrite option
:-)
"Tracy McKibben" wrote:
> serge calderara wrote:
> > Dear all,
> >
> > I have an database backup from SQL server2000.
> > How can I import it inside SQL server 2005 ?
> >
> > regards
> > serge
> Use the RESTORE DATABASE command...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>