Hello,
FYI, I'm using Visual Studion 2005 with SQL server Ex Edition in my developer PC. So the problem now is how i can migrate the database into my web hostin provider?. The provider also use the same version of SQl server. What i noticed the express editon dont have function to import or export.
Anybody iin here know how to solve? Right now, i'm create the databse using my controll panel in my web hosting then i create tables using management studio express, this way i must do twice works, 1st in my developer PC then into my web hosting..please anybody give a hand please
I already copy web site include the app_data into my web hosting, but unfortunately i dont know the connections strings? when i ask the provider they told me to use the management studio for the databse for connection into their server.
i also noticed if i install the application which use sql server dataabse it can be install the database including the tables and the data, so how is it i want to make my web site including the database be like installer. Like CommunityServer Forum? i just install into web hosting..is it possible? How the way? Thank you
note: I'm newbie in VS and Sql server
Please some one in here...I'm really needs this solution..i must create new application using VWD and SQL ex..i have a dateline..please the expert on in here..|||Hosters each have their own way to allow you to move your database from the development environment onto the hosting platform. I can't tell how your hoster expects this to be done from your post.
Many Hosters will create a database for you and then let you create objects in the database they give you. Typically they provide you with some kind of web interface to accomplish this. It is common for Hosters to provide you with a way to run scripts to create objects in your hosted databases. If that is the case, you might be interested in the Database Publishing Wizard which we have just made available as a Community Technology Preview. The DPW is a new tool we are working on to make it easier to move databases from development to Hosting site using scripts. This is a CTP, so it's an earlier release. There is more information on the site about how to use the tool.
It sounds like your Hoster might allow you to connect Management Studio to thier site. If that is the case, you can still use this tool to generate your entire database as a script file and then use Management Studio to run the script when you're attached to the Hosters server.
You're right that Import/Export isn't part of SQL Express, but this tools should meet the need for uploading databases to a web hoster.
Mike
|||Thank you for your reply, I'm using Sql server 2005 Express Edition. Is it Database Publishing Wizard valid with this Sql Server Version.|||Sorry one more things,,is ti possible if we doing a mirroring databse using sql server express edition. If it can how the way? For example, i want mirror my databse from my web hosting provider with my PC in mmy office. is it possible? Thank you|||I alrealdy install the database Publishing wizard but the problem is i'm a newbie and i do not know how to use it. When i open it just only Ms dos appear. Is it normal?
For Information, my web hosting provider use Plesk control..so the database is store through Plesk system. So with this scenario is it some body in here have an experience like me..Please tell me how the way?
|||The Database Publishing Wizard is compatible with all Editions of SQL Server 2005. It may also be compatible with SQL 2000, I'm not sure. We're in CTP right now for the DPW, so it's not complete; this first release only supports a command line interface so it is normal that it just opens the DOS window when you run it. You will need to type your commands in at the drive> prompt per the instructions listed in the window. Some basic usage information is available on the tool site and there is a forum there also where you can post questions specific to the wizard.
I'm not familiar with Plesk so I'll have to let someone else advise you there. You will probably need to get more information directly from the technical support team at your web hoster site if you have problems working with thier interface.
Mike
No comments:
Post a Comment