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.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Need general advice

Author  Topic  RandyHJ Starting Member 5 Posts Posted - 2009-08-19 : 11:30:53 I am a web developer. My company's website is basically an online version of our product catalogs. We display detailed product specifications on our products pages that are pulled from SQL Server 2005 databases. Currently we do not have Integration Services installed on SQL Server and we do not have a SQL Server DBA. The data we eventually store in SQL Server 2005 comes from Adobe InDesign files. We copy the data from InDesign into Excel 2003, then we remote desktop into SQL Server and upload the Excel file to the Server. After that we use the SQL Server Import/Export Wizard to copy the data from the Excel worksheets into the database tables. Somtimes we have problems with the formatting of our data changing when we use the wizard. We also have problems keeping our development SQL Server instance sychronized with our production SQL Server. I am looking for advice on steps that I could follow to make the transfer of data easier and the synchronization between the development and SQL Server instances easier. Thanks.