mssql 客户端 -mysql,在使用MSSql Server作为后端的客户端PC上安装应用程序

I have one WinFormApplication which using MS-SQL server As Database.

Now of course Database i have created on my PC(Developer''s PC) is not available on Client PC where i will install my Application.

Then what is the best criteria or practice to Add Database at Client PC''s MS-SQL server.

or

any buddy can tell where could i find script of my database created using

SERVER EXPLORER Visual-Studio 2010 so i can directly execute it on Client PC?

So i can access it my Application.

Please Help.... Thanks.......

解决方案

To generate the script:

Open the SQL Management Studio

right click on your database

Tasks -> Generate Scripts

in the dialog box press Next until asking where to save it

click the Advanced button

Look for the Types of data to script

Select Schema and data

Press OK and Next

Then the file has been generated.

It will generate your database with all the data.

Thanks..

in development pc, you can use Server Explorer to generate script to an text file

in client pc, use "sqlcmd" via command line to insert data in that text file

p/s: for me, i''m use "sqlcmd" command to export and import database :)