In the older SQL2000 I used DTS to upload local copies of databases to my web sites. Now it appears with SQLServer2005, DTS isn't the preferred method - in fact you have to do special things to make DTS available. I have to use SSIS to upload a database, but there doesn't seem to be any examples or help for how to upload a whole database - tables, indexes, constraints, stored procs, views, data and all.
I've found the export wizard, but that wont upload a table object, keeping the indexes (and therefore the foreign key links in other tables etc) all intact. It insists on creating new indexes. I've looked at using Visual Studio to create SSIS packages, but it seems to do that requires a whole lot of steps for each and every table, which might be hundreds of tables in a database. Unless I've read that stuff wrong. How do I copy all my tables, their indexes, defaults, constraints etc etc, AND the data, with indexes intact from my local Dev version SQLServer2005 to my web host's SQLServer2005?? Oh yes, and I have 21 databases to do - which will account for about 350 tables in all. And that doesn't count the stored procs and views! So I don't want to have to go through that laborious process table by table if I can avoid it. IN the SQL2000 server making up a "export data" and saving it as a DTS package took about 5 minutes to configure for the whole database and I could save it for later use. There doesn't seem to be an equivalent unless I've missed something (which is definitely possible!) Can anyone help? Cheers Mike Kear Windsor, NSW, Australia Macromedia Certified Advanced ColdFusion Developer AFP Webworks Pty Ltd http://afpwebworks.com Full Scale ColdFusion hosting from A$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2444 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
