|
figgles
|
|
 Posted: Mon Jul 27, 2009 9:57 am |
|
 |
 |
|
|
HSM has an MS-SQL instance they're hosting for us and I'd like to perform regular local replication of this database for web development purposes. I have successfully connected with HSM's server at geyser using Microsoft SQL Server Management Studio Express 2005 (did they pay someone for that wonderful name?)
An HSM technician suggested using DTS. However, DTS does NOT appear to be supported in Microsoft SQL Server Management Studio Express (2005) I tried the Database Publishing Wizard, but I can not connect with my local instance; and I get outofmemoryexceptions when I try to run the .sql output from my geyser-hosted db.
I would love any ideas on this -- TIA
|
|
|
|
tedjtw
| Joined: 08 Feb 2005 |
| Posts: 103 |
| Location: Connecticut |
|
|
| Posted: Mon Jul 27, 2009 6:55 pm |
|
|
|
|
|
My first guess would be true replication is not supported by HMS on a shared SQL Server. There are things that just can't be available in a shared environment.
If you use SQL Server developer addition in house you might be able to use some of the BIDS functions, it should connect to the HMS database.
Try looking at EMS, My Manager, tool for MS SQL Server. There might be some options with that tool.
HTH
|
|
|
