I am doing one E-commerce Application , throgh C#. & sql server express editon. Both my Local & Web Hosting servers are in sql server express 2005. I designed Databse Throghly, to my local server. Now I want to Transfer tables to my web server. I have already Sql server mangement studio Express. I can not do.. I spent, more than 5 yrs time..
Please help asasp..
Thanks
Partha
SSIS is not a component of SQL Server Express. You should be able to script the table structures and run the resulting scripts against the remote server. As far as data, there are some utilities available for scripting your data to INSERT statements if you search the internet. Or you can do it yourself by using the management views in SQL Server 2005.
No comments:
Post a Comment