Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
morphviper
Yak Posting Veteran
60 Posts |
 Posted - 2007-01-10 : 13:58:22
|
| I have been given the task of figureing out how to export 90 some tables of data into a file that can be imported into another express db on the other side of the country and no one have to touch it.I have been reading a ton of stuff that says 2005 is great for/with xml. I haven't found a good example of what I need.I have approx. 90 tables that collect data on a mobile unit using SQL Express. I need to clear the data from these tables every night so that the db is empty of all data. I then need to send this data to a server on the other side of the country and have a SQL 2005 Server receive this data and run something to insert the data that I just pulled from the mobile units. This is suppose to happen behind the seens. I have figured out the mode of trasport for the data, I just haven't figured out the SQL side of everything??Any help would be great. |
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2007-01-10 : 15:30:40
|
| The ability to transfer data between instances of SQL Express doesn't really have anything to do with XML, but it seems you've decided to use XML as the transport format. That works, but there are others as well.Start with [url]http://msdn2.microsoft.com/en-us/library/ms191268.aspx[/url] in Books Online to learn about generating XML output and pulling it back in.You will have to code your own logic to make this happen "behind the scenes" as you desire. SQL Express doesn't support any built in schedulers.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
 |
|
|
morphviper
Yak Posting Veteran
60 Posts |
Posted - 2007-01-10 : 16:14:16
|
| I have decided that xml might be best because I might have to rearrange it at some point for other applications and I thought I might use an xslt to do this.. Is there a better way? |
|
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2007-01-11 : 13:59:15
|
| Not so much better, just different. You can also use BCP, which is documented in Books Online and supports a couple different export formats. It's mostly about what you're familiar with and what works for you.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
|
|
|
|
|
|
xml in express