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 |
|
fcoreyesv
Starting Member
18 Posts |
 Posted - 2006-08-08 : 09:11:39
|
| Hello,I am working on a project in which we converted an application from Access to SQL. In earlier version, data was easily distributed to new customers because all we had to do was to copy tables into the access database and send the file along with the installation package.In this new version we need to do the same but SQL offers several ways to distribute data. One is sending a detached database as a template. This approach brings a situation we want to avoid. It requires running a routine with DMO specifying a server side path to locate the detached database and attach it to the newly installed server. Some of our customers do not have IT personnel and we want to do this as automated as possible. On the other hand, I am trying to create CSV or Txt files but when I try to copy the information into a SQL table, I get some errors created by Carriage Returns in some text fields. Basically my question is if someone has done a project where data needs to be distributed along with an application and the data needs to be imported after the server and the application are installed, all of this done by scripts or installation applications. Any comment will be greatly appreciated,Jose Reyes |
|
|
|
|
|
Distributing data