i have a data in ms access which i want to import to sql server 2005 express..
thank you
erd wrote:
where is the import and export data function in sql server 2005 express? i have a data in ms access which i want to import to sql server 2005 express..
thank you
Hi erd,
Me too. I'm facing the face issue too..|||
I have used DTC that came with SQL2000 that our company uses, if you don't have SQL2000 you could download the Trial edition and just install the SQL Client Tools which don't expire after the trial time period. This might raise some kind of licensing issues so you might want to check with MS first.
|||I have used DTC that came with SQL2000 that our company uses, if you don't have SQL2000 you could download the Trial edition and just install the SQL Client Tools which don't expire after the trial time period. This might raise some kind of licensing issues so you might want to check with MS first.
hello akula,
thanks for your advice.. i have install the DTC tool .
from your exp with using the tools, can you use sql 2k enterprise manager with sql express?|||
I have been told that you can use 2K enterprize manager with SQL Express. That being said I perfer the Visual Studio IDE and there is also a free light version of the SQL 2005 manager that can be downloaded as well.
|||where could i download trail version of sql 2000 so i could use their client tool for the import/export of sql server 2005 express?thanks|||There is no import/export wizard in Management Studio Express. The import/export wizard in full Management Studio relies on SQL Server Integration Services to move the data, but SSIS is not present when only SQL Server Express is installed.
You can import the data from Access by creating a linked server to the Access database and then writing make table queries to copy the data. There are examples of how to create the linked server to an Access (JET) database and execute queries in the help topics for sp_addlinkedserver in Book Online. (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-1b184aff558f.htm)|||i tried installing the books online, but after installing it my mgt studio express wont work anymore..whats seems the prob?
i installed sql express through the visual basic 2005 express
thanks.|||I was about to post something to the effect that you could do this in code as well. Either using that method or the load from access into a dataset, transfer data from set into SQLExpress.
HERE'S THE PROBLEM WITH THIS APPROACH
SQLExpress is targeted to new developers or developers looking for a simple solution. Not having a method of simply transfering data into SQL Express for those developers that don't have the privilage of owning SQL2K or SQL2K5 is a grave mistake. With the current state of affairs those users without the full edition of SQL have to either write complex code to port some file types like Excel or go from Excel to Access to SQLExpress. In fact given the targeted market I would almost expect a better tool for SQLExpress then for SQL.
Not having an optional tool todo this only encourages people to go out and use Access,MySQL,PostgreSQL.|||Management Studio Express does not run when the full Management Studio is installed. When Books Online is installed, it is writing a registry key that is used by Management Studio to indicate that it is installed, so MSE won't start.
See this discussion for more information: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=132643&SiteID=1|||i dont understand what you mean by Full Management studio?
i just installed the sql server 2005 express edition included in the visual basic express edition then installed the books online then my mdt studio express wont work anymore...
what should i do to make everything run
thanks|||
Thanks for your feedback.
Microsoft does have development tools for tranforming data and debugging stored procedures that are shipped with SQL Server 2005 Developer Edition and Visual Studio, respectively. Management Studio Express is envisioned to be a "lean and mean" tool appropriate for managing SQL Server Express server instances - doing backups, adding logins, setting permissions and so forth.
SQL Server 2005 Developer Edition is the full SQL Server 2005 Enterprise services and tools, including SSIS and the Import/Export Wizard in Management Studio. The difference between Developer Edition and Enterprise Edition is that the license for Developer Edition only allows the servers and tools to be used for development purposes.
If you are doing serious (or even not-so-serious) database development, I would encourage you to consider purchasing a copy of SQL Server 2005 Developer Edition. I believe the cost for a stand-alone Developer Edition is around $60, which basically covers the cost of the media and packaging - a screaming deal in my book. Developer Edition also comes as part of some MSDN subscriptions and in the higher Visual Studio skus, so you might already have a copy.
|||do you have to uninstall the existing sql server 2000 enterprise edition to install the sql server 2005 trial version?does it have to be clean install?|||
I have been told that you can use 2K enterprize manager with SQL Express. That being said I perfer the Visual Studio IDE and there is also a free light version of the SQL 2005 manager that can be downloaded as well.
Hi akula, are you refering to using SQL 2005 server management studio?
strangely after installing sql2005 exp, I have since been unable to use win wk enterprise manager..|||
do you have to uninstall the existing sql server 2000 enterprise edition to install the sql server 2005 trial version? does it have to be clean install?
Hi erd,
you don't necessary have to. However to do an 'upgrade' you have to ensure
that your system has the meet sql 2005's minimum requirement stated in the sql2005 details website as well as doing some preparation work before performing the upgrade.
Its adviseable to follow the steps recommended by microsoft as not doing so may result in partial installation of sql 2005.
No comments:
Post a Comment