Importing XML in SQL Server 2000 in .Net 2.0

Hello Kent,
I realized, I am having SQL Server 2000 for this problem, and not 2005
(To many projects I guess). So, SSIS won't be possible. Same goes for
XML typed column.
Is there option for bulk upload in SQL Server 2000.
Kent Tegels wrote:
> Hello Neo,
> Okay, so let me ask this: are you simply interested in loading the XML int
o
> the database in some batch operation or do you both load the orginal data
> into SQL Server and modify stored values from XML?
> If it this is a simple ETL (former) case, SSIS would be my tool of choice.
> If you're looking to both load and update from XML, SSIS is still usable,
> but the solution might look a little different.
> If you simply putting the XML into a XML-typed column, consider using open
rowset(bulk)
> instead.
> More details helpful. :)
> Thanks!
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/Hello Neo,
N> I realized, I am having SQL Server 2000 for this problem, and not
N> 2005 (To many projects I guess). So, SSIS won't be possible. Same
N> goes for XML typed column.
BCP or SQLXMLBulkLoad then. Not an easy problem to solve with those tools.
If you can use the .NET 2.0 framework, you might want to look into the SqlBu
lkCopy
class. That might help.
Thanks!
Kent

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