How do you set up replication when none of the tools allow it?
Apparently, (and i hope I"m wrong here) none of the freely available tools allow replication to be set up.
I have dozens of Databases hosted with my web sites on a shared server, running SQLServer2005 (dont know what "Yukon" means so I'm not sure if it's that or not). I have local versions I work on, doing updates, some sites I build locally, and "publish' the site contents once a week, other sites I have to download the remote data to my local machine so I have complete copies to work on and do development.
However there doesnt appear to be any equivalent to DTS that I used to use in EnterpriseManager/SQL2K.
Oh I know there's SSIS- but apparently no way to replaces whole tables in one database with their equivalents in another. And there's a Transfer Database task predefined in SSIS, but you have to have database creation privileges to run it. No one on a Shared server has that - only the Control Panel does.
So there's replication. But none of the tools freely available seem to have replicatoin available. No menus on any of the tols I have use the word "replication" anywhere, and books on line doesnt have the word anywhere searchable.
So what do i do? At the moment I have to use SSIS in debug mode, using a separate query window to delete all reacords in a table, then run SSIS in debug mode to upload (or download) a single table at a time.
But in total i have 352 tables over all my databases. this is extremely tedious and time-consuming, considering it all used to happen every night automatically using my old SQLServer2K and EngMrg.
What can i do now?
Here are the tools i have available:
EMS SQLManager for 2005 Lite - no mention on any menu of replication or SSIS
Microsoft Visual Studio 2005 - no mention of replication on any menu
Microsoft SQL Server Management Studio 9.00.1399.00 no replication mention anywhere
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework Version 2.0.50727 Installed Edition: IDE Standard
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer Version 9.00.1399.00
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer Version 9.00.1399.00
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers Version 9.00.1399.00