Importing Database

I have SQL Server 7.0 and I am going to update to SQL Server 2000, Can I import the database? Can I make a backup from SQL Server 7.0 and then to restore with SQL Server 2000. (I have tape backup).
Thanks and Best Regards,
hi jose,
yes, you can restored backup file of SQL 7 database to SQL Server 2000. SQL 2000 will upgrade
the SQL 7 database during the restore process. Once restore process is over run update
statistics on all tables, ideally WITH FULLSCAN.
Vishal Parkar
vgparkar@.yahoo.co.in
|||Please refer to these links that will provide you all the information that
you would possibly need to perform the upgrade:
How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
http://www.microsoft.com/technet/pro...y/sqlugrd.mspx
Upgrading from SQL 7 to SQL 2000
http://msdn.microsoft.com/library/de...us/instsql/in_
upgrade_5jw3.asp
This link will give you all about SQL installation
http://msdn.microsoft.com/library/de...us/howtosql/ht
_install_5vsj.asp
FAQs to know before you plan the upgrade
http://support.microsoft.com/default...b;en-us;261334
Hope this helps.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Importing Database

I have SQL Server 7.0 and I am going to update to SQL Server 2000, Can I imp
ort the database? Can I make a backup from SQL Server 7.0 and then to restor
e with SQL Server 2000. (I have tape backup).
Thanks and Best Regards,hi jose,
yes, you can restored backup file of SQL 7 database to SQL Server 2000. SQL
2000 will upgrade
the SQL 7 database during the restore process. Once restore process is over
run update
statistics on all tables, ideally WITH FULLSCAN.
Vishal Parkar
vgparkar@.yahoo.co.in|||Please refer to these links that will provide you all the information that
you would possibly need to perform the upgrade:
How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
http://www.microsoft.com/technet/pr...oy/sqlugrd.mspx
Upgrading from SQL 7 to SQL 2000
http://msdn.microsoft.com/library/d...-us/instsql/in_
upgrade_5jw3.asp
This link will give you all about SQL installation
http://msdn.microsoft.com/library/d...-us/howtosql/ht
_install_5vsj.asp
FAQs to know before you plan the upgrade
http://support.microsoft.com/defaul...kb;en-us;261334
Hope this helps.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Importing data using WebService

Hello,

i'm searching a way to update data using a web service.

For example, i want to store the temprature of cities in a database. I have a table with all the cities and an other table storing the temperature.

I have access to à web service that give temperature for the cities...

i hope you understand what i want to do... ;-)

thanks a lotThe web service task can access the web service and store the SOAP envelope as an XML file locally. You can then access the XML file in a data flow task using the XML Source Adapter and use the data in your data-flow as you would any other data.

-Jamie|||Ok !

Where can i find a tutorial for using webservice task ?|||BOL should always be your first port of call. Try ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/5c7206f1-7d6a-4923-8dff-3c4912da4157.htm and if there isn't enough there to help use the "Send Feedback" link.

-Jamie|||It's not clear from the question whether the web service gives you address for a specific city or for all cities. Likely it's the former in which case you'd likely want to call the web service through the script component that wraps the SOAP call and does a little of it's own caching to avoid redundant web service calls.

If the shoe fits, feel free to wear it.|||Hi all,

I am using the web service task with XML source to insert data from a web service into an SQL Server database. But I have a problem with the XML output from the Web Service Task. It looks li this:
<?xml version="1.0" encoding="utf-16"?>
<ArrayOfBooking xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" >
<Booking>
<BookingDate xmlns="http://tempuri.org/">2007-04-12T16:14:33.9210023+03:00</BookingDate>
<FlightDate xmlns="http://tempuri.org/">2007-04-12T16:14:33.9210023+03:00</FlightDate>
</Booking>
<Booking>
<BookingDate xmlns="http://tempuri.org/">2007-04-12T16:14:33.9210023+03:00</BookingDate>
<FlightDate xmlns="http://tempuri.org/">2007-04-12T16:14:33.9210023+03:00</FlightDate>
</Booking>
</ArrayOfBooking>

and because of this xmlns="http://tempuri.org/" that is met almost everywhere I cannot create a proper XSD Schema , that is needed for the XML source. If I remove this xmlns="http://tempuri.org/" , then everything works fine . The web service I am calling has this namespace xmlns="http://tempuri.org/" in the [WebService(Namespace = "http://tempuri.org/")] . I am writing the web service so I can change it as well if this is needed. Do you have any ideas how to solve this xmlns="http://tempuri.org/" problem?

Thanks in advance.

Regards,
pc

Importing data using WebService

Hello,

i'm searching a way to update data using a web service.

For example, i want to store the temprature of cities in a database. I have a table with all the cities and an other table storing the temperature.

I have access to à web service that give temperature for the cities...

i hope you understand what i want to do... ;-)

thanks a lotThe web service task can access the web service and store the SOAP envelope as an XML file locally. You can then access the XML file in a data flow task using the XML Source Adapter and use the data in your data-flow as you would any other data.

-Jamie|||Ok !

Where can i find a tutorial for using webservice task ?|||BOL should always be your first port of call. Try ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/5c7206f1-7d6a-4923-8dff-3c4912da4157.htm and if there isn't enough there to help use the "Send Feedback" link.

-Jamie|||It's not clear from the question whether the web service gives you address for a specific city or for all cities. Likely it's the former in which case you'd likely want to call the web service through the script component that wraps the SOAP call and does a little of it's own caching to avoid redundant web service calls.

If the shoe fits, feel free to wear it.|||Hi all,

I am using the web service task with XML source to insert data from a web service into an SQL Server database. But I have a problem with the XML output from the Web Service Task. It looks li this:
<?xml version="1.0" encoding="utf-16"?>
<ArrayOfBooking xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" >
<Booking>
<BookingDate xmlns="http://tempuri.org/">2007-04-12T16:14:33.9210023+03:00</BookingDate>
<FlightDate xmlns="http://tempuri.org/">2007-04-12T16:14:33.9210023+03:00</FlightDate>
</Booking>
<Booking>
<BookingDate xmlns="http://tempuri.org/">2007-04-12T16:14:33.9210023+03:00</BookingDate>
<FlightDate xmlns="http://tempuri.org/">2007-04-12T16:14:33.9210023+03:00</FlightDate>
</Booking>
</ArrayOfBooking>

and because of this xmlns="http://tempuri.org/" that is met almost everywhere I cannot create a proper XSD Schema , that is needed for the XML source. If I remove this xmlns="http://tempuri.org/" , then everything works fine . The web service I am calling has this namespace xmlns="http://tempuri.org/" in the [WebService(Namespace = "http://tempuri.org/")] . I am writing the web service so I can change it as well if this is needed. Do you have any ideas how to solve this xmlns="http://tempuri.org/" problem?

Thanks in advance.

Regards,
pc

importing data to MSDE

Hello,
What is the best way to import data to a client's MSDE
database from our website? We want our client to log onto
our website so we can update a table on the client's PC. I
need a little direction on this, not sure which is the best
way to go.
Thank you,
Randers
hi Randers,
Randers wrote:
> Hello,
> What is the best way to import data to a client's MSDE
> database from our website? We want our client to log onto
> our website so we can update a table on the client's PC. I
> need a little direction on this, not sure which is the best
> way to go.
> Thank you,
> Randers
perhaps you could provide an ftp based solution to download new data from
your website and the MSDE remote client proceed with a scheduled job to bulk
insert it..
you can even set the job to notify via mail of the success/failure of it...
(just use an SMTP solution like http://www.sqldev.net/xp/xpsmtp.htm )
or mail them, but this become more manual as the final user has perhaps to
read the mail, save the attached file in some defined file system position
and let the scheduled task process the file..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.msde:20144
send them an sql file as they will not be able to login to msde remotely
"Randers" <rmonroe@.aulcorp.com> wrote in message
news:06cc01c52e3e$1e481e20$a501280a@.phx.gbl...
> Hello,
> What is the best way to import data to a client's MSDE
> database from our website? We want our client to log onto
> our website so we can update a table on the client's PC. I
> need a little direction on this, not sure which is the best
> way to go.
> Thank you,
> Randers

Importing Data from Excel to update existing fields

I have an excel file that contains column A with names of components and products followed by column B which has each respective quantity on hand. I want to import that data to our website's SQL database that has a products table with a column, Pf_ID, that has only product names not component names and In_Stock which contains out-dated information that I want updated from column B of the excel file.

I think I've figured out how to use DTS and update the two fields, but I'm afraid that when everything runs new entries will be created with component information. Is it possible to specify that only rows where Pf_ID matches some row in column A that same row's column B will be used to update the data in In_Stock. I may have just made things too confusing than they need to be, but I don't have much experience with EM or Excel.

I'm also considering trying to write a macro that will match Pf_IDs in an exported excel file of the products table and take rows out of the excel file with current quantity information putting them in a new excel file to import into the website's database.

Please help, this is getting really confusing.I would bcp the data into a staging table, then use sql to do whatever you have to do.

But that's just me

MOO|||I'm not sure what bcp stands for ... I've only seen dts. I think your idea of using a staging table to query data from sounds good, but I kind of want this to be as simple a process as possible. Something that relatively anyone with instructions could click buttons and have done routinely.|||use dts to bring the excel data into a staging table
(a table created just to store data in the middle of a coomplex import)
then use an update statement against the staged data to update the destination data
(use the transact sql task)

For a more straightforward (but more advanced) method you might consider using the data driven query task and you could eliminate the staging table.

once you get this running you can set it up as a batch file or script or even call it from a sp. so anyone can run it.|||I've called tech support and checked permissions on the product table, but niether of us can seem to get this query to work when importing data from an excel workbook, Peach$. Is there something wrong with my query?

Here's what the support said when he tried:

It doesnt appear to be working running as SA either. I get a Error Line 3 near ) and then the db is read-only.

I cleared active connections to the DB and even stopped access, but it still appears to be locked by something, or perhaps the table is protected somehow?

--Raj

Here is the actual query:

update ASI.dbo.Product

set ASI.dbo.Product.In_Stock = (select `Peach$`.`Quantity On Hand`

from `Peach$`

where ASI.dbo.Product.Pf_ID = `Peach$`.`Item ID`)

where exists

(select `Peach$`.`Quantity On Hand`

from `Peach$`

where ASI.dbo.Product.Pf_ID = `Peach$`.`Item ID`);

Sorry for the lag time with a reply. I hope this gets read now.