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 |
|
doncx
Starting Member
4 Posts |
 Posted - 2007-10-03 : 07:35:39
|
| I develop for a number of clients, and rely on DTS in SQL Server 2000 to transport schemas and data to remote client databases.I've been using the Express edition of the SQL Server 2005 Management Studio to access these databases lately, but it does not have the DTS feature, which is horribly inconvenient when I need to add tables, etc to remote databases.If I purchase the Developer Edition of SQL Server 2005, and install the Management Studio on my workstation (my development db is on another machine), will it give me full DTS support for remote databases, or is DTS limited to one db only?I've searched MS and this obscure info doesn't seem to be there anywhere. Does anyone know this?Thanks! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-03 : 07:43:53
|
See "Integration and Interoperability" section on this Microsoft pagehttp://www.microsoft.com/sql/prodinfo/features/compare-features.mspxquote:
Notes: In the following table, the "Comments" column provides comments on the specified feature. Numbers next to check marks indicate footnotes that appear at the bottom of the page. SQL Server 2005 Developer Edition and Evaluation Edition are not listed in the tables. These editions have the same feature set as the Enterprise Edition; the only difference between these editions is the licensing policies.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
doncx
Starting Member
4 Posts |
Posted - 2007-10-03 : 09:32:17
|
| Thanks, Peso.I had seen that page. It says that the Developer Edition is the same as the Enterprise Edition.It also says "the difference between these editions is the licensing policies."So, I wonder how that is enforced (or IF its enforced) in regard to DTS.Its not the 49 bucks, its the hassle of installing it all only to find out that it doesn't deliver the functionality I need.Still looking for confidence that it does... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-03 : 09:47:01
|
What about licensing do you not understand?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
doncx
Starting Member
4 Posts |
Posted - 2007-10-03 : 11:30:54
|
| The language I first read about DevEd indicated that only one person/server/database could be accessed. With your prompting above, I have read Microsoft's license language, and am satisfied that there are no contrived limitations.I've placed my order. Thanks for your prompting. |
|
|
|
doncx
Starting Member
4 Posts |
Posted - 2007-10-05 : 13:22:35
|
| Drat! Now I'm in need of more assistance.I've purchased and installed the Developer Edition of SQL Server 2005 Management Studio.I still can't find an easy way to add tables and their data to a remote database.I can make CREATE scripts to create the remote tables, but when I then go to import data to them, SSIS insists on re-creating them (so there was no need to script them) with no constraints like primary keys, identity columns or default values.Am I missing something? This shouldn't be so tough!Any help would be appreciated. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-05 : 23:41:14
|
| Which task did you use? Tried with transfer objects task in bids? |
|
|
|
|
|
|
|
|
DTS in 2005 Developer Edition