Hello, I am using Visual Studio Web Developer 2005 Express Edition with MSSQL 2005. I need to import my db into the db in Godaddy.com web server. How do you know export MSSQL db in VSWD to csv file? I was trying Teratrax. But I am not sure how to browse for the database on my local machine.My local machine runs on XP Home Edition and I write my ASP.NET app with Visual Studio Web Developer Express Edition. How do I find out what my server name is so that I can connect to the database of my application? I don't think it is localhost because I don't have IIS running on my machine. From my understand VSWD has its own web server. But I am not sure how to connect to my data baswe so that I can export the database to CSV file using Teratrax.ThanksJacthemanus
Hi How can I export a MSSQL DB (table, SP, View, data) to a single csv file? I can export them to a sql file through Publishing Wizard, but how can I export it to a csv file? Thanks for help
i was planning to create a database migration tool .. its a certain database of a DMS (document management system) to another DMS (two different DMS)... from DMS using msde 2000 server .. and tranfer to a DMS using a postgre sql or mssql .. depends ..
they have different table structures and names . . :D
i was thing of what language shall i use.. or what language is the best to work on this kind of project :)
I am working on a couple fo the ASP.NET walkthoughs and I would like to practice with a Database that I created in Access. I realize that I could use the Access DB, but I would like to learn to work with a more industrial strength DB. Is there a method to export to MSSQL server 2000 from Access ?
i have a MSsql file wich i want to export information from. Every post in the database should be exportet to a own single file with all the information about the post. So from a single question to the database i would like to have a lot of files named by a speciel filed i the post. I also want to be able to design what the excel file should look like.
How can I Export Database with foreing Key and primary key.
Operation is that SQL2005 Management Studio/Database/Tasks/Export Data
Before Version is SQL2000 we can Selected Copy Object and data between server and then Use Default Options click checked and Select Copy Index, Copy Foreing Primary key vs vs
But this options is not found in the SQL2005 Management Studio/Database/Tasks/Export Data wizard or I can't found it.
How can I export foreing Key and primary key with SQL2005 Management Studio/Database/Tasks/Export Data wizard.
While attempting to set up sql replication in MSSQL 2005 one of my user databases is now in the systems database folder. I need to move it back to the user databases folder. Any help would be greatly appreciated.
We have a Prinicipal, a Mirror and a Witness server. We have automatic failover configured between the Prinicipal and Mirrored server. When we stop MMSQL service on Prinicipal, not all the databases failover to the Mirrored instance. Any suggestions would be welcomed as we have a tight deadline to get this in Production.
I am new to ms SQL. I only have the use of the Enterprise Manager. Creating tables I understand. However I am confused on how to add data to a table or view the data in a table. Can this be done through Enterprise Manager? If I am adding a large amount of data do I have to use the query window. This seems like a tedious method. In Access yo have a form basically pop up where you can type in the record sets. Any advice would be appreciated! Sincerely, Bill Bequette
Would any body be able to suggest the best way switch a Lotus .nsf file to Ms SQL database or even to an Access?
I have a .nsh file that I am able to see the contents of but not the database structure, and rather then rebuilding the database and manually inserting the content I would like to import all the information from an old .nsf file that appears to have restriction on it.
I need to export a database, x, of a server, X, to another database, y, of a server, Y and I need export the database schema only, not include the data. Does anyone know how to do that? Many thanks for replying.
I am very new to asp.net. I really mainly use PHP but want to migrate to asp.net, but it doesn't seem that easy.I am creating a page for peson to pay a subscription page where they will enter personal information an credit card information.I created the form for this with validation controls.I don't know however how to write the form data to the mssql database.I am using mssql 2005, but i would need a work out for the 2000 version as well.
Hello,Is it better to use a DSN connection or using a connection string Set Connection = Server.CreateObject("ADODB.Connection") Which is easier to use and more reliable? Also could I have all the connection info on one page and then just include it with a include statment everytime I need to query the database?? Thank you, Rich
I've come from the asp world into .NET and I have looked all over the web for the proper way to make a database connection to a MSSQL server and all I have found is samples of connections to Access databases. Can anyone point me in the direction of how to create a db connection for microsoft sql server.thanks
We have set up an user acceptance server with a database that is the same as production. However, I have been told that this database and server may be used for applying fixes rather than user acceptance.
To avoid confusion over which database is on which server, it might be a good idea to rename the database. I am not sure if this can be done un der mssql 6.5?
1)Can I rename a database?
2)If so, how can I do so?
Which system tables would I use to update?
Any information you can furnish will be appreciated. THanks.
When using the "Management Studio" how do I create a database? When it starts up, I only seem to have the option of connecting to a database, while not actually creating one :S
David writes "Dear sir, I've installed VS.NET 2005 Professional many times and find that the MS SQL Express 2005 is running. My ambition is to log into this server so that I can convert my MySQL database into it. What is the default; Hostname Port Username Password
What tool is provided so that I might execute my schema to create a database in this server. This 'schema' will obviously have many tables inside. Most SQL products provide some type of utility program where one can create, edit, delete databases and an adminstration program. I see nothing of yours in my Programs -> MS SQL Server 2005 -> SQL Computer Manager. Thank you, David Kennedy"
Hello, another question from a newbie to mssql.Is there a way of allowing access to database only by providing username andpassword (disabling trusted connection and preventing administrator toaccess database through enterprise manager or otherwise without supplyingusername and password)?What I would like is that my application upon instalation creates databasewith appropriate tables (already done this) and somehow solely creates andmanages user list and passwords so that there is no access to database otherthrough application. (Application would create a backdoor account shouldsomething go wrong)
I've made af site in Visual Web Developer. On that site i've made a database and it worked finde when I first uploaded it to my FTP as a database file on the server. But due to security problems, my web hotel host has deactivated that possibility. Så now I have to put my data and tables into the MSSQL 2005 Database the host uses. Now here's the problem.
1: How do I do that?
2: How do I get tha tables I've made i Visual Web Developer over in SQL Server Management Studio Express så that I can upload it?
Has anyone had a problem transfering a database to a server. This is the first time I have done this. I have a site and sqldatabase hosted by a hosting company and I am supposed to transfer my database This is what I'm doing
From the Start Menu, select "Programs" -> "Microsoft SQL Server" -> "Import and Export Data" then click "Next". In the "Server" field, type in the Name or IP of the source server (your server), choose "Use SQL Server Authentication," type in your username and password, choose your database from the "Database" field, click "Next". Note: You can also use Windows Authentication if the SQL server is a local server. In the "Server" field, type in the hostname of the DiscountASP SQL Server (this is listed in your hosting control panel), choose "Use SQL Server Authentication," type in your DiscountASP database username and password (this was sent in your database order confirmation email), choose your database from the "Database" field, click "Next". Choose "Copy objects…", click "Next". Uncheck Use Default Option. Click Options, uncheck "Copy Database users and database roles", "Copy SQL Server logins", "Copy object-level Permissions". Leave next window as is, click "Next". Click "Finish".
It seems to work ok untill it gets to about 90% done then a message says "There has been an error" and gives no more info. Can anyone help me out
Does anyone know of a good (free) tool that will compare the structure of two databases. Something that will compare Stored Procedures and Views would be great.Thanks.
Hi all, Well, I have created an applicatin in asp.net and it connect to MSSQL database, and it work fine.
There is another application which was developed in Oracle and the database is oracle 8i.
Well, wat i want is whenever a form is submitted from the asp.net application, the data is inserted in the MSSQL server database and the Oracle8i database also.
We are working on using a database as a publisher and a remote database as a subscriber for one replication in Canada.
WE havw just been told that another application on a different server(publisher/ distribution) wants to replication to our database as a subscriber.
We also will need(as a publisher/distribution) to replication to a second subscriber database after we completely test the first replication to Canada.
Therefore my questions are:
1) Can a database on a local database -- our database -- on one server be a publisher and subscriber to ther different databases?
2)has any one been involved with replication on a database used both as a publisher and subscriber to different replications requirements?
What are the pitfalls aside from the scheduling conflicts?
3) In terms of database space requirements, how much disk space extra do we need? What guidelines should we use? For each table as an article, assuming we are doing the full table, do we add 100% more space or what?
Hi.. When I go to my MSSQL 2000 database--> properties-->Databse size is 1500MG and the space available is 305MB
But I don't understand how space available come from. As I had put my Database file and Transaction log file as unrestricted file grow. And put automatically file grow by 10% for both file and log
Why is the limit come from ?
Besides, I have a database which indicate space available as 0M in the database properties but it is still functioning. why?
Here is the case. I have up and running database on MSSQL server. My client deliver me updates. Since now they were as INSERT statements, but they decided to change some stuff at their side. Now the updates will come as pairs of files (.dbf and .mdx) for each table...
Several months ago I installed what I thought was an unlimited license of MSSQL Database Server 2000. This weekend the database expired. What can I do? I don't want to lose the data. If I attempt to reinstall the software, will that work? We are in the process in purchasing the software but not for a few months. The database is used to store and retrieve data in our OutStart server. Any idea is helpful.
